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 |
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 2006-04-11 : 08:43:53
|
| hi when i execute ... select * from Members where address = '6257 Rockwell's'ERROR :Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near 's'.Server: Msg 105, Level 15, State 1, Line 1Unclosed quotation mark before the character string ''.Kindly help me how to solve ' |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-11 : 08:51:11
|
| Double the single quoteselect * from Members where address = '6257 Rockwell''s'MadhivananFailing to plan is Planning to fail |
 |
|
|
shanmugaraj
Posting Yak Master
219 Posts |
Posted - 2006-04-11 : 09:03:27
|
| Thanks |
|
|
|
|
|
|
Replace '