Originally Posted by blocker

hello guys.!

I just have 1 problem right here. I have a variable declaration below:

Help with Code Tags

vb Syntax (Toggle Plain Text)

myVar ="Argie's"
"Select * from  [my Table] where [my Field] ='" & myVar  & "';"

myVar ="Argie's" "Select * from [my Table] where [my Field] ='" & myVar & "';"

When i execute the query, it returns error because the myVar value contains Quotes and sql server does not allow it because it is its a reserve character.

Pls help.!

Thank you for your time.

God bless on this mother earth.!