Re: String concatenation script

["Shipley, Lisa A." <lshipley@SEWSUS.COM>]

You will need to enclose the comma with single quotes || ',' ||

-----Original Message-----
From: Keith Hazelwood [mailto:hazlk0@CHMCC.ORG]
Sent: Thursday, May 31, 2001 7: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