INSTR function
INSTR():
Returns the position of the first occurrence of substring in given string and return 0 if that sub string not in given string.
Syntax:
INSTR(str,substr)
Example:
SELECT INSTR(’sub string’,’string’);
Output:
5
Leave a Reply
You must be logged in to post a comment.
