Re: String concatenation script

[ANDERSD2 <ANDERSD2@OAKWOOD.ORG>]

Guessing this is to be part of a "dynamic SQL statement", so...

let $Plan_Type = 'in (' || '''' || '10' || '''' || ',' || '''' || '11' ||
'''' || ')'

SQR needs four single quotes (') to be equated as the quote.  The above
statment would SHOW as...
in ('10','11')

Good luck

-----Original Message-----
From: Keith Hazelwood [mailto:hazlk0@CHMCC.ORG]
Sent: Thursday, May 31, 2001 8:59 AM
To: SQR-USERS@list.iex.net
Subject: String concatenation script


I am trying to convert the statement:

$Plan_type  IN ('10' , '11') into

$Plan_type = 'IN (' || chr(39) || '10' || chr(39) || , || chr(39) || '11' ||
chr(39) || ')'

The error that I am receiving is (SQR 4005) Extra comma in expression.

Any help would be truly appreciated.

Keith Hazlewood
Children's Hospital
Cincinnati, Ohio

I am new to writing SQR's in Peoplesoft.

SQR/4.3.4/Oracle 8.0.5/Peoplesoft 7.5