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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.