passing variables to sql string

[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

 

[Kylie]

dont worry - worked it out - you use double quotes instead