single quotes imbedded in sql string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to format an sql query (to avoid errors) when a single
quote is imbedded in a parameter e.g.
select field2 where field1 IN ('abc', 'd'fg','hij').
The ' in d'fg cause an error, but the database field actually contains the
'. Sometimes this is found where feet are abreviated to '
thank you in advance.
 
NJS said:
Does anyone know how to format an sql query (to avoid errors) when a single
quote is imbedded in a parameter e.g.
select field2 where field1 IN ('abc', 'd'fg','hij').
The ' in d'fg cause an error, but the database field actually contains the
'. Sometimes this is found where feet are abreviated to '
thank you in advance.
Click to expand...

Double the quotes. E.g. (Access 2000 & greater):

str = "d'fg"
str = Replace(str, "'", "''")
' str now equals "d''fg"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use List Box to select a paramter for a query 5
query parameters 2
Missing data in report 5
Make-table query with around 2 ml records taking too long 0
Delete duplicates records without data in field name 5
Turn Off Access Field Re-name? Calculation fields in query 2
Reading Tab Delimited Data With Imbedded Double Quotes 3
trouble with union query 2

Back
Top