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')
>Is there have simple way to put escape character infront some special char like ',"...
>
>
>For Example :
>
>
>Change from -
>
>INSERT INTO customer (cusNo,remark)
> VALUES ('C01','THIS'S A TEST, 123')
>
>To
>
>INSERT INTO customer (cusNo,name,ramark)
> VALUES ('C01','THIS\'S A TEST, 123')
>
--sb--