V4RB v1.x: Apostrophe in SQL Query

[Jules Jacquot]

Le 3 juin 05 à 06:59, Ruslan Zasukhin a écrit :

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

valentina doesn't follow the referrals of SQL92 ?  :-))

best

jules

>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>

Il faut faire vite ce qui ne presse pas pour pouvoir faire lentement  
ce qui presse