POSITION

Purpose

This function returns the position in the string, string, at which the string, search_string, first appears. If this is not contained, the value 0 is returned.

Syntax

position::=

Usage Notes

  • If one of the arguments is NULL, then NULL is returned.
  • The functions INSTR and LOCATE are similar to this function.

Example

Copy 
SELECT POSITION('cab' IN 'abcabcabc') POS;