easy one - reserved characters

[sladd]

I am writing a module to construct a dynamic sql statement. Inside of this string, I need to include " marks.

example:
dim sqlstr as string
dim t1 as string

t1="table1"

sqlstr = "select " & t1 & ".* where " & t1 & ".location="austin""

I of course get an error becuase the quotes I need to put around the word austin are taken as a control character. How can I build my statement to include these quotes?

 

[BillPower]

Try:

sqlstr = "Select " & t1 & ".location, * From " & t1 & " Where " & t1 & ".location = '" & "austin" & "'"

Good Luck