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 |
|
Capt_Ron
Starting Member
45 Posts |
 Posted - 2005-04-06 : 13:44:20
|
| How can I insert a field into my table if the field includes a single quote like (person's) I know this has got to be fairly easy, but I can't figure it out.Right now I remove single quotes (among other characters and sequences) before I write the Insert statement.Thank you in advance.Ron. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-06 : 13:48:01
|
duplicate them.' -> '' not "Go with the flow & have fun! Else fight the flow  |
 |
|
|
satishdg
Starting Member
10 Posts |
Posted - 2005-04-07 : 02:16:17
|
| do like this 'Person' + ' + 's' |
|
|
|
|
|
|
Noobie Question on Single Quotes