Omnidex SQL Function: POSITION

Find the position of string1 in string2. The POSITION function returns the position of a string (string1) within another string (string2). If string2 is of length zero, the result is 1. If string1 occurs as a substring within string2, the character position where string1 first occurs is returned. If neither of these conditions is true, the result is 0. The return data type is a 4-byte INTEGER.

String comparisons are case-sensitive. Use the UPPER and LOWER functions around string1 and string2 to produce a case-insensitive search.

POSITION(string1 IN string2)

Required. Any valid text string. The text to search for.

Required.

Required. Any valid text string. The text in which to search for string1.

SELECT company, 
POSITION(UPPER('sys') IN UPPER(customers.company)) 
FROM customers WHERE company='systems'
 
Company                 POSITION
--------                ---------------
Camco Systems           7
SoftSys Corp            5