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.

soni29 (soni29@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, esquel@sommarskog.se

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