>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao