|
|
|
POSITION SQL Function
Syntax
POSITION ( char_exp1 IN char_exp2 )
Description
The scalar function POSITION returns the first occurrence of char_exp1 in char_exp2.
Example
SELECT POSITION ( 'Fa' IN 'FairCom' )
FROM customers ;
POSITION
--------
1
1 record selected
Details
If any one of the expressions evaluates to be null, POSITION returns null.
Note: SQL-99 and ODBC compatible
