[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Including inverted commas within the STRING statement



At 04:43 PM 1/23/97 +0000, Harry at Planet Connect
<harry@PLANETCONNECT.CO.UK> wrote:
>How can I include a ' within a STRING  statement (so as to build a
>dynamic variable).

You have to comment it with an additional ' ie:

STRING 'bp.release_group = ' '''' $rg '''' BY '' INTO $dynamic_rg

where the four ' in a row preceding and trailing $rg represent

1) opening quote

2) comment quote

3) quote written into $dynamic_rg variable

4) closing quote

Enjoy,

Bob