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

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Hi Shailesh,
   Here is how the Function looks 
INSTR
Returns the numeric position of sub_value in source_value or zero (0)
if not
found.  The search begins at offset offset_value.  This function
returns a
float value.

Syntax: dst_var =       instr(source_value, sub_value, offset_value)


HTH 
Datta. 
--- Shailesh Sugandhi <shailesh.sugandhi@patni.com> wrote:
> 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
> 



                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 

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