String Function POSITION( x IN y)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select position('o' in 'tutorialspoint') from (values(1));

Result

+———————-+
| EXPR$0 |
+————————+
|   4    |
+————————+