Use apostrophe in query

[lb1]

I have an SQL statement where my search criteria could include an apostrophe. The parameter is pased to the query.
What could I do to correct the following query to accept an apostrophe in the test parameter?

For example, il the search criteria is "four o'clock" how can I replace the ' ?
Thanks in advance.
louis

 

[swampBoogie]

Use two ' in your query

select * from t where c = 'four o''clock'

Best is to do a replace on the search value, e.g. using VB-script

q = "select * from t where c = '" & replace(search,"'","''") & "'"

 

[WildHare]

searchString = "Four o" & chr$(39) & "clock"

ASCII 39 is the single quote.


This should do it for you.

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm