V4RB v1.x: Apostrophe in SQL Query

[Jules Jacquot]

Le 3 juin 05 à 04:49, Cindy Brown a écrit :

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

try

'O''Connor'

best

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

L'homme vulgaire accuse les autres
Le sage n'accuse que lui-même

BOUDHA l'éveillé