amywolfie wrote:
Thanks David. I'm fine with T-SQL, but it seems that every time I try
to reframe a statement in JetSQL, I get tripped up by the string
requirements.
Are there any concise rules as to when to use a double quote, when to
use a single?
You can use either in JetSQL but I tend to stick with single quotes for
code portability, if you have a string with a quote in it[1] then just
double it up, e.g.
update mytable set mycolumn = 'Trev''s Tip of the Day'
[1] mainly because most users don't know where the apostrophe key is,
including me apparently, I automatically typed ' instead of `.