How do i insert ampersand(&) in a string while insert

[hafeez]

Hi,
I am trying to insert a string which is having ampersand in it,how do i escape &.

Ex: I have a table with a column saying status varchar2(30).

Now, i want to insert a string like thick & thin in that column.

INSERT INTO DUMMYTABLE VALUES('thick & thin');

It is prompting for thin when i gave like above..

Please help me regarding this.

Thanks and Regards,
Hafeez.

[rmiao]

Use escape character in ms sql server, check books online for details.