" in SQL 1

[smash81]

Hello,
I need some help on how to put a " in my string.How do i escape this as the query does not work.
For example how would i say
str="select * from table where name="abc""

 

[Geee]

In SQL you wrap char values with single quotes not double quotes, so you query should be...

str="select * from table where name='abc'"

If you do need to use " in a string for whatever reason, i think you need to put 3 of them for VBScript to use 1, like this...

Response.Write "I Said """Hello There""" to him."

I think!

Gee -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-