need help handling ' when building sql

[SteveInBeloit]

I am building a where statement in vb .net.
"Where myTextField = '" & me.ddl.selectedvalue & "''"

work except for when there is an apostrophy in the selected value, such as
"Steve's books"

What do I do?
Thanks

 

[cjard]

read the PQ link in my signature. then read the DW2 link to understand how to make the IDE build your queries for you - it does it properly

 

[SteveInBeloit]

cjard.
I have used PQs before - based on your link!! This time I am building dynamic SQL based on 10 dropdownlists the user may or may not have clicked on. Some are equals, and some are likes. I didn't know if I could do that.

 

[cjard]

Well, the theory is still the same: you dynamically add the parameters to the query text!

Read this: http://www.vbdotnetforums.com/showthread.php?t=22028

And also consider this: http://www.vbdotnetforums.com/showthread.php?t=22066


I tend to use the second approach.. The first approach really was to solve a massively varied search requirement (any field of any form)