V4RB v1.x: Apostrophe in SQL Query

[Cindy Brown]

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.

-- 

Cindy Brown
Programmer
SchoolMaster

Kowhai Programming Systems
PO Box 198, Invercargill
81 Marama Avenue South, 9RD Invercargill
Phone (03) 213 1243
Fax (03) 213 1248
Mobile (021) 354 930
<http://www.kowhaiprogramming.com/>