Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2008-10-26 : 22:11:51
|
| I am using parameters for search. If I search for something like Mike's it throws error.The single quote is the problem. How can I resolve this.Thanks |
|
|
singularity
Posting Yak Master
153 Posts |
Posted - 2008-10-26 : 22:18:06
|
| Use two apostrophes. where yourstring like 'Mike''s%' |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 00:07:09
|
| Refer below link to understand how SQL Server deals with single quoteshttp://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx |
|
|
|
|
|
|
Incorrect syntax near 's'.