including string in string

[jeff06]

sql:
contract="new"

i want to use it in sql string
vba:

sqlstring = ""
sqlstring =sqlstring&"contact="new""

This does not not work
how can I include string in string?
Thanks.

[malik641]

Hey jeff,

When you use quotes inside string values, you have to place two quotation marks "" to signify a single quotation (") inside the string.

And shouldn't you use apostrophes ' for SQL strings?

[vba]sqlString = "" ' No text at all
sqlString = sqlString & "contract = ""new""" ' No text plus 'contract = "new"'[/vba]

[jeff06]

Thanks