V4RB v1.x: Apostrophe in SQL Query

[Ruslan Zasukhin]

On 6/3/05 5:56 AM, "jda" <jda at his.com> wrote:

>> 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'

Right, query should looks as:

        WHERE LastName = 'O\'Connor'
    

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]