MS SQL Server New Users - Update Breakout Character

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Update Breakout Character

TriAdX@aol.com

2005-04-06, 8:02 pm

I am trying to update a column and my data has multiple ' in it. What is
the breakout char so that it will no think that the ' is the end of my data?

Adam Machanic

2005-04-06, 8:02 pm

Use double-single-quote:

'This isn''t an interesting sentence.'

--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

"TriAdX@aol.com" < TriAdXaolcom@discuss
ions.microsoft.com> wrote in message
news:5E58B09C-BB94-4F46-A7D6- 120DFBC540C7@microso
ft.com...
> I am trying to update a column and my data has multiple ' in it. What
is
> the breakout char so that it will no think that the ' is the end of my
data?

Sponsored Links