|
|
Posted by Dan Guzman on 09/06/05 06:29
I found this from the 'quotation marks' entry in the Books Online index.
From the 'Using char and varchar data' topic:
<Excerpt href="acdata.chm::/ac_8_con_03_7mch.htm">
When using single quotation marks to delimit a character constant that
contains an embedded single quotation mark, use two single quotation marks
to represent the embedded single quotation mark, for example:
SET @MyCharVar = 'O''Leary'
</Excerpt>
--
Hope this helps.
Dan Guzman
SQL Server MVP
"NickName" <dadada@rock.com> wrote in message
news:1125967013.923190.247670@g14g2000cwa.googlegroups.com...
> Thank you very much, Dan, works perfect.
>
> On a related note, BOL does not cover it, how could one find a solution
> to a problem similar to this one without resorting to this NG?
>
Navigation:
[Reply to this message]
|