>Hi all,
> I need to insert Single Quote, Ampersand and some other symbols/characters into SQL table. What to do in order to escape these characters? And where can I find a list that contains the characters that need to be escaped? TIA.
>
>Wan

Wan,
Using SQL Pass-thru you can use the T-SQL function CHAR() to insert these characters.

lcsqlexec = [insert into mytable (field1, field2) values (char(39),char(38))]
=sqlexec(lnconn, lcsqlexec) && inserts single quote in field1 and ampersand in field2

HTH.