[sqr-users] Is INSTR available in SQR?

["Shailesh Sugandhi" <shailesh.sugandhi@patni.com>]

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