Find Quotes

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

Hi All,

I have data that comes from an external source. Every now and then they
forget and have quotes for inches in the description.

I want to setup a query that checks for " quotes.

I can I do this?
 
SELECT InStr([TABLE_NAME],'"') AS Expr2,
Replace([TABLE_NAME],'"',"") AS Expr1
FROM A
WHERE InStr([TABLE_NAME],'"') >0;

For some reason I always have trouble looking for double-quotes using
something like this in the criteria: Like "*'"'*"

However doing an InStr seems to work. Notice that it's a single-quote
double-quote single-quote combination.

Also the second field returned shows an example of the Replace function. You
could use something like it to fix the data in an update query. For example:

Update To: Replace([TABLE_NAME],'"',"Inches")
 
Hi All,

I have data that comes from an external source. Every now and then they
forget and have quotes for inches in the description.

I want to setup a query that checks for " quotes.

I can I do this?
Click to expand...

WHERE YourTable.FieldName Like '*"*'
 
Back
Top