Apache Drill - String Function INITCAP(x)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select initcap('drill') from (values(1));

Result

+————————+
| EXPR$0 |
+————————+
| Drill  |
+————————+

The Initcap function returns the result as the first character of the string becomes capitalized.