Cant use hyphen in SQL!!!
I don't know about Sybase, but with Interbase you can enclose strings
either in single or double quotes. e.g.
UPDATE table SET NAME = '14" Monitor'
UPDATE table SET NAME = "Joe's Garage"
When you need to do something like Joe's 14" Monitor, you can do it
UPDATE table SET NAME = "Joe's " || '14" Monitor'
>When I build a query in Delphi, (which is executing on a Sybase database) I
>can't include a hyphen in the text data! Can anyone tell me how? I'm
>doing something like this.
>query.SQL.Add('update table set name = "' + editboxName.Text + '" where
>and the edit box referred to has something like: Joe's Garage or
>whatever, with a hyphen.
>I get a database error every time. If I take out the hyphen, it works
>fine. If I use a function to
>add a second hyphen, it shows up with 2! Can anyone help me please? You