String lookup functions in orcal and SQL Server

INSTR (C1,c2[,i[,j])

function searches for a specified character in a string, returning the location of the specified character;

"description" multibyte character (kanji, full-width, etc.), calculated as 1 characters

"Parameters" C1 the string being searched for

C2 the string you want to search

I Search start position, default is 1

J-J-Occurrence position, default 1

"Return" value

Example

Select InStr (' ABCDEFGC ', ' C ', up) from dual;

Returns: 8

CHARINDEX (C1,c2[,i])

function searches for a specified character in a string, returning the location of the specified character;

"description" multibyte character (kanji, full-width, etc.), calculated as 1 characters

"Parameters" C1 the string you want to search for

C2 string to be searched

I Search start position, default is 1

return value values

Instance

Select CHARINDEX (' C ', ' ABCDEFGC ', 4)

Returns: 8

The "summary" needs to be noted that although the functions of the INSTR and CHARINDEX functions are the same, the c1,c2 means the opposite, and the INSTR function is more powerful, you can find the location of the first J occurrence.

String lookup functions in orcal and SQL Server