How do you insert text with double quotes into SQL server.

[ironhide1975]

Ok this one has been driving me crazy for years. I know that you can't insert a double quote into SQL server because thats what forms the query, and a singular quote you need to double up on two in order to put that into database.

But say you had actual text with one double quote

such as...

this is a double quote "

How do you get that into the text field in a database? Is there any way at all using ASP classic?

 

[Chopstik]

This may help you (at least from an ASP Classic standpoint): thread333-898275

------------------------------------------------------------------------------------------------------------------------
If you don't have a sense of humor, you probably don't have any sense at all.
- Anonymous

 

[SonOfEmidec1100]

In VB I tend to just concatanate the string around the quote character

qry  = "UPDATE mytable set name = 'this is a double quote " & Chr(34) & "' WHERE......."

 

[stevexff]

Alternatively you could just

qry  = "UPDATE mytable set name = 'this is a double quote ""' WHERE......."

as VB.NET uses the same idea of doubling the quotes.

 

[dbomrrsm]

easy:

create table Quote (field1 text)


insert into Quote (Field1)
values ('this is a double quote "')

select * from Quote

BTW theend of the values line is quote (") and '

[blue]DBomrrsm[/blue]

 

[ironhide1975]

If someone enters a quote into say, a form text box. How do you grab that from the form and then convert/replace the characters to submit?

 

[dbomrrsm]

select replace('this " should not be in here','"','')

[blue]DBomrrsm[/blue]