RE: [sqr-users] Is INSTR available in SQR?

[SandlerA@DFO-MPO.GC.CA]

I believe that the function you are looking for would be the equivalent of
the SQL 'IN', not INSTR.  As far as I know, there is no equivalent function;
however, you could write you own procedure to do this.  The procedure would
be based on the INSTR function.

If you are using Oracle, and retrieving Plant_Id as part of your select, it
may be easier to use the DECODE expression in Oracle to create a variable
when this condition is met.

Aaron Sandler


-----Original Message-----
From: Shailesh Sugandhi [mailto:shailesh.sugandhi@patni.com] 
Sent: July 14, 2004 1:40 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Is INSTR available in SQR?

Hi,

I have following code.

if (($Plant_id = 'DE01') OR ($Plant_id = 'DE02') OR ($Plant_id = 'DE07') OR
($Plant_id = 'DE11') OR ($Plant_id = 'DE12') OR ($Plant_id = 'DE14') OR
                ($Plant_id = 'DE15') OR ($Plant_id = 'DE16') OR ($Plant_id =
'DE31') OR
($Plant_id = 'DE63') OR ($Plant_id = 'DE64')
                Or ($Plant_id = 'DE68') OR ($Plant_id = 'DE71'))

I want to change this to single line code something like INSTR of Oracle. If
$Plant_Id contains DE then process it.

Can someone help me regarding this?

Thanns in advance.

Regards,
Shailesh


-----Original Message-----
From: sqr-users-bounces+shailesh.sugandhi=patni.com@sqrug.org
[mailto:sqr-users-bounces+shailesh.sugandhi=patni.com@sqrug.org]On
Behalf Of sqr-users-request@sqrug.org
Sent: Tuesday, July 13, 2004 4:34 PM
To: sqr-users@sqrug.org
Subject: sqr-users Digest, Vol 5, Issue 11


Send sqr-users mailing list submissions to
        sqr-users@sqrug.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://www.sqrug.org/mailman/listinfo/sqr-users
or, via email, send a message with subject or body 'help' to
        sqr-users-request@sqrug.org

You can reach the person managing the list at
        sqr-users-owner@sqrug.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sqr-users digest..."


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users