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?