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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Inserting names into a table,

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.
Go to Top of Page

soulchyld21
Starting Member

28 Posts

Posted - 2012-02-01 : 07:36:50
Thanks
Go to Top of Page
   

- Advertisement -