Hi Usman,

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'

(BOL Using char and varchar data)

Charles
> -----Original Message-----
> From: Usman Farhat [SMTP:Usman.[Email Address Removed] Sent: Wednesday, October 23, 2002 10:03 AM
> To: LazyDBA.com Discussion
> Subject: String Problem ! Urgent
>
>
> HI Guys !
> I got some situations where i need to use exec (string ) method ..
> As we know we can use ' ' sighns
> for enclosing strings but if we wana add a substring between
> that string what character we will use
> I mean ' ' ' ' does not work also ' String "Substring
> " ' does not work .... So what will exact Format for these sort of
> situations .... If some one can help me please ....
> Thanks In Advance .... Usman
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page