Thanks, David.
>FWIW double single quotes also works for Sybase.
>
>>If you're refering to MS SQL Server, than you've to double a single quote inside a string literal encloused in the single quotes. The ',' (comma) and '"' (double quote) aren't special characters in such string literal and don't require any special handling.
INSERT INTO customer (cusNo,remark)
>> VALUES ('C01','THIS''S A TEST, 123')
>>
>>
--sb--