Re: Quote within Quote

[Christine Sessler <cms41@CORNELL.EDU>]

I use something
like this:  

LET $quote   = ''''

let $dyn_plan_list =
$dyn_plan_list || $quote || &bpt.benefit_plan || $quote

Chris

At 10:43 AM 11/01/2000 -0600, you wrote:
> I would like to create a string that builds
> with values that are VARCHAR2
> but i cant put quotes within quotes... Is there any way to denote
> that???
>
> Let $SQR_CUST_ID = $SQR_CUST_ID || ',' || $CUST_ID
>
> will create $SQR_CUST_ID:  111,222,333
>
> but should look like this  '111','222','333'........... etc  so
> that later
> i can put this string in a WHERE clause
>
> WHERE BV.CUST_ID IN ($SQR_CUST_ID)
>
> any ideas??? thanks...
>
> Jim 


************************************************************
Christine
Sessler                            
HR/Payroll
Team                              
Cornell
University                  
120 Maple Avenue
Ithaca, NY  14850

O: 607.255.8149
F:  607.255.6982
Email: cms41@cornell.edu
************************************************************
A little
consideration, a little thought for others, makes all the difference. -
Winnie the Pooh