question on sql

[Inimicum]

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?

[brucevde]

Use single quotes to surround your string criterias.

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

[Destined Soul]

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

ie:

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

[Inimicum]

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

[Destined Soul]

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