How to insert a CARRIAGE RETURN in SQL query.

something like: SELECT "Dear Sir:" + CHAR(13)+CHAR(10) + "This is"
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions

"Pat" <pwang@uclink.berkeley.edu> wrote in message
news:3e8296ff$1@tnews.web.dev-archive.com...
>
> Hi,
> does anybody know the sql statement to insert a value like
> "Dear Sir:
>
> This is
> "
>
> into a varchar field.
>
> I tried insert into table values("Dear Sir:\n\n"), it doesnot seem
working.
>
> Thanks
>