Re: Insert a single quote in to a variable. -Reply

[Tony DeLia <tdelia@EROLS.COM>]

I like to keep the code neat using a variable set to a quote at the
beginning of the program... then use the variable for all quote
requirements... this bypasses the 4-quote for 1-quote nonsense SQR
uses...

let $q = chr(39)   ! Single Quote
..
..
let $quote     = $q || $hdr || $q
let $sqlstring = ' and a.emplid = ' || $q || $id || $q
etc....

                                     -Tony DeLia


Mark Kraft wrote:
>
> let $quote = '''' || $hdr || ''''
>
> always use 4 single quotes to get 1
>
> Mark Kraft
> kraftm@gunet.georgetown.edu
>
> >>> Ngo Bao Chau <baochaun@MAIL.TRANSCONTINENTAL.CA>
> 12/11/98 10:46am >>>
> Hi everybody
>
>         Could you tell me how could I insert a single quote into a variable.
>
> let $quote = ''' || $hdr || '''
>
> Merci
>
> Ngo Baochau
> mailto:baochaun@mail.transcontinental.ca
> tel: (514) 335 - 1466/4943
> http://www.transcontinental.ca

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com