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 |
|
Trininole
Yak Posting Veteran
83 Posts |
 Posted - 2013-07-17 : 12:23:49
|
| How do you include a word with an apostrophe in an SQL in statement without getting an error msg? For example this syntax:where provname1 IN ('Children's')With that syntax above, I would get an error message.Roger DeFour |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-17 : 12:29:57
|
| where provname1 IN ('Children''s')------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Trininole
Yak Posting Veteran
83 Posts |
Posted - 2013-07-17 : 12:32:41
|
| Thank youRoger DeFour |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-17 : 13:49:36
|
| See the reason here: http://myshallowsqlblog.wordpress.com/escaping-single-quotes-in-sql/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
IN Statement