Apostrophe escape in SQL statement

[Kenny62]

HI - how do you escape the apostrophe and quote symbol in a text field when used in a sql statement.

i.e. SELECT name FROM mytable WHERE names='qwerty's'

Will this escape sequence work against an Access DB?
Thanks in advance.

Ken

 

[dbomrrsm]

SELECT name FROM mytable WHERE names='qwerty''s'

 

[amorous]

You can use the replace function which does same thing as suggested by DBomrrsm.

fieldname=Replace(fieldname,"'","''")

Thanks

VJ

 

[Kenny62]

Thanks - all is well.