INSTRB
INSTRB(string1, string2[, n[, m]])

Searches string1 to find string2 and returns the byte position in string1 where string2 begins.

INSTRB is similar to INSTR, except that the return value represents a byte index into stringr1, not a character index. When a single-byte character set is used, INSTR and INSTRB return the same result; a difference only occurs when using a multibyte character set.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.