The syntax of IndexOf functions is shown below:

IndexOf(search-string, string1, string2, string3,......, case_flag)
The indexof function is to find the position of the search-string in the specified list of strings. You can pass as many strings as you want for the list.

If case_flag is 0, then the search is case insensitive. Any other integer means, the search is case sensitive.


indexof('ETL', 'Informatica','Power Center','ETL') returns 3.
In the above example, the String ETL is searched against the list of strings 'Informatica','Power Center','ETL'. The index starts from 1.

Eample for case insensitive search:

indexof('oracle','mysql','ORACLE','postGres',0) returns 2.