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.