Quick Ref.
Compatibility
INSTR(s1, s2)
Engine OK Alternative
ingres no POSITION(s2 IN s1)
mysql yes
oracle yes
postgres no POSITION(s2 IN s1)
sqlserver no PATINDEX('%'+s2+'%',s1)

INSTR

INSTR(s1, s2) returns the character position of the substring s2 within the larger string s1. The first character is in position 1. If s2 does not occur in s1 it returns 0. 

 INSTR('Hello world', 'll') -> 3
In this example you return the position of the string 'an' within the name of the country.

Results
See also: