Quick SQL query question

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 :)

VB Code:

SELECT * FROM client WHERE surname LIKE '" & Replace(cdata.surname, "'", "''") & "%'"