V4RB v1.x: Apostrophe in SQL Query

[jda]

>Hi,
>
>How can I exclude the ' apostrophe character in an SQL Query. For example,
>Select * FROM Students WHERE LastName = 'O'Connor'. I've tried O\'\Connor
>but that doesn't seem to work at all.
>
>Any help would be appreciated.
>

Did you try

'O\'Connor'

?

Jon