>Thanks Larry,
>
>I tried text, but didnt work when I insert a record with following.
>
>~ ` ! @ # $ % ^ & * ( ) _ + | \ / "
>' : ; ? > < , +
> 123456789
>abcdefghijklmnopqrstuvwxyz

That's because of the single and double quotes embedded in the string. You could convert these to their ASCII equivalent or use a variable for this.

lcstring = [~ ` ! @ # $ % ^ & * ( ) _ + |  \ / " >' : ; ? > < , + > 123456789] + ;
[ abcdefghijklmnopqrstuvwxyz]
=sqlexec(lnconn,'insert into mytable (varfield) values (?lcstring)')

Both nvarchar and varchar fields can have all 256 ASCII characters in it. It's just a matter of bypassing the the SQL delimiter issues.

HTH.