hello guys.!

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

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.!

hello guys.!

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

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.!

Anyway ive already solved the problem..Just make the qoutes double.