passing variables to sql string

K

Kylie

Hi there

I am trying to write a standard sql string using a WHERE
clause as follows:

"SELECT...FROM...WHERE name = '" & strVariable & "'"

however my strVariable is a coming from a name field
which sometimes has apostrophes in it. Any suggestions
on how I can stop the "'" s from breaking my code??

Thanks,
Kylie
 
Top