question on sql

I have a tmpsql

tmpsql = Select * From Customer where Customer.Customer_Name = "Jon"

only problem is, u have to have the sql statement in " "
and when it gets to the "Jon" it believes it's the end of the variable, how to I make vb include " in the string?

Use single quotes to surround your string criterias.

VB Code:

tmpsql = "Select * From Customer where Customer.Customer_Name = 'Jon'"

Another way to put " into your strings is to use it twice.

ie:

VB Code:

Dim str As String
str = "My name is Bob ""Wild"" Smith"
MsgBox str

But brucevde is right in that you should use the single quotes ' around strings. I think some versions of SQL only use the single quotes. (But I have been known to be wrong.) However, it doesn't hurt to use them. ;)

Destined

thanks that works, although in a msgbox it shows up as a ' and not a " but it works so who cares :-)

Quote:

---

Originally posted by Inimicum
thanks that works, although in a msgbox it shows up as a ' and not a " but it works so who cares :-)

---

I just tested mine (cut'n pasted into program) and it came out using "

Oh well. :)

Destined