insert double quotes into sql server table

[soni29]

hi,
just wanted to know if i need to insert a string with double quotes in
it into a sql server table, do i need to use any delimeters, like \"?
an insert like:
insert into producttable values(key, "double quote text")

where i need the "double quote text" to go in like that, with the " "
at both ends.

Thank you.

[Erland Sommarskog]

soni29 (so****@hotmail.com) writes:

just wanted to know if i need to insert a string with double quotes in
it into a sql server table, do i need to use any delimeters, like \"?
an insert like:
insert into producttable values(key, "double quote text")

where i need the "double quote text" to go in like that, with the " "
at both ends.

You double them.

This is a kind of information that you easily can find out by using the T-
SQL Reference in Books Online. By using this wealth of information, you
can get the answers to your questions quicker.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp