SELECT instr(lower(abc), '123') sql_keyword ------ sql_func ----------------------- sql_ident ----- sql_func --------- sql_ident ----- sql_ident --- sql_comma - sql_string ----- lower: Returns a copy of the given string with all ASCII characters converted to lower case.