The instring function returns either the starting position of the substring, str2, within str1, or zero if that substring does not exist. The form Instr(n, str1, str2) returns the nth occurences of the substring, str2, within str1 or zero if that substring does not exist.

Checks to see if a value is in the string. select instr(last_name,'a'),last_name from employees;

Instrument lights.

Instructions

Instructional