Re: String concatenation script

["Beller, Jay" <JBeller@LBISOFTWARE.COM>]

If your trying to create a string variable, it appears as though your comma
in the middle of the expression also requires single quotes, like the '10'
and '11' literals:

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

-----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