0

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

1
Contributor
1
Reply
2
Views
8 Years
Discussion Span
Last Post by blocker
0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.