The syntax of IndexOf functions is shown below:

Code:
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.

Example:

Code:
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:

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