How to insert new line in a query

[katy]

Hi

I have a table in which one of the columns is a varchar.
I have to insert the following in the column :

'Thanks,

Yours,

<name>'

How do i get the new line characters in the insert query.

[jezemine]

on sql server, you would do something like this:

insert into MyTable (mycol) values ('thank' + char(13) + char(10) + 'you')