apostrophe in SQL statement

[Anon]

help!!!!!!

i have a problem with apostrophes in strings that are being appended to an access database using ODBC. i can write anything to the database so long as there is no apostrophe in it.....

does anybody know of a way that i can solve the odbc problem but still keep the apostrophe in the text that is written to the database???

thanks
Mike

[Anon]

Replace each occurence of an apostrophe with two.

e.g.

insert into ogrish values('Neil','O''brien')

is a valid sql statement that will insert the value

Neil O'brien

[Anon]

Thank you very much for this tip!!