Hyphens(') problem

[HotBob]

What is the best way to deal with hyphens.

I am passing in a search name into a sql query but if the name has a hyphen such as strName = o'connor

Then I need to pass in the strName = o''connor

Other wise it errors

Any ideas?

 

[AtomicChip]

Use stored procedures instead..

If you don't want to or can't for some reason, use the Replace() method on the string variable that holds the name to replace ' with ''

-----------------------------------------------
"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy

 

[vbkris]

the best way in .NET side would be to use parameters. i think it does the same implicitly...

Known is handfull, Unknown is worldfull