[DUG] Single or Double quotes?

[Phil Middlemiss]

Sometimes I can use double quotes when adding a string to an SQL query 
using Firebird with the Interbase Components. Other times I get an SQL 
error and have to resort to using single quotes (which is a pain if the 
string contains an apostrophe).

Can someone set me straight on the conditions under which single or 
double quotes can be used in a query?

Cheers,
Phil.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: phil.vcf
Type: text/x-vcard
Size: 250 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20051213/b79e650b/phil-0001.vcf