Functions

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.

Syntax

POSITION(string1 IN string2)

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

IN
Required.

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

Example

select company,
position(upper('sys') IN upper(customers.company))
from customers where company='systems'

Top