Dealing with apostrophe - SQL Server Forums

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

SQL Server Development (2000)

Dealing with apostrophe

Author

Topic

lane0618
Posting Yak Master

134 Posts

Posted - 2003-06-24 : 15:05:25

How do you deal with inserting a value that contain an apostrophe (" ' ")?

INSERT INTO Test
(recieverEmail)
VALUES ('mfg'ora')

Thanks!

Lane

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-06-24 : 15:42:54

Double up the '



CREATE TABLE #MyTable(MyField VARCHAR(50))

INSERT INTO #MyTable(MyField)
VALUES ('Dannyboy O''Bannon')

SELECT * FROM #MyTable

DROP TABLE #MyTable

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources