Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
INSTR(s1, s2)
Engine OK Alternative
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: