Progress
SQL-92
Guide and Reference


INSTR Function

Searches character string char_expression1 for the character string char_expression2. The search begins at start_pos of char_expression1. If occurrence is specified, then INSTR searches for the nth occurrence, where n is the value of the fourth argument.

The position (with respect to the start of char_expression1) is returned if a search is successful. Zero is returned if no match can be found.

SYNTAX

INSTR ( char_expression1 , char_expression2 
   [ , start_pos [ , occurrence ] ] ) 

EXAMPLE

This example illustrates the INSTR function:

SELECT cust_no, last_name
    FROM customer
    WHERE INSTR (LOWER (addr), ’heritage’) > 0 ; 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095