Hi

If I need to use an SQL query such as...

SELECT * FROM client WHERE surname = " & cdata.surname & "%"

...what would be the correct syntax to use if the surname was O'Brien for instance.

Any surname that has a ' in it causes a syntax error.

Can someone help me please.

Thanks