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 |
|
soulchyld21
Starting Member
28 Posts |
 Posted - 2012-02-01 : 04:58:33
|
| I am trying to insert a name like O'Bailey into a table using an insert statement, however because I need to enclose my names in single quotes 'O'Bailey' (sql syntax) Im getting an error! how can I work around this? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-02-01 : 05:14:34
|
Use another single quote to maske the other single quote:'O''Bailey'
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
soulchyld21
Starting Member
28 Posts |
Posted - 2012-02-01 : 07:36:50
|
| Thanks |
|
|
|
|
|
|
Inserting names into a table,