>> String values should be enclosed in single quotes, in Delphi, you
>> can easily escape single quotes with two single quotes by using
>> the QuotedStr function.
>>
>> O'Reilly then becomes:
>>
>> 'O''Reilly'
>
>
> Thanks for your reply with this question. I just re-read my post and
> realized that I wasn't being as clear with this as I could have been.
> When I wrote 'double quotations' I meant two single quotations side by
> side, and not a single double quotation (").
>

Two single quotes to surround a string value doesn't make sense:
you're starting a string, ending it immediately, having the value and
then starting and ending a string again ;-)



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com