String Function BYTE_SUBSTR(x,y [, z ] )

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select BYTE_SUBSTR('Drill',1,2) from (values(1));

Result

+-+
| EXPR$0 |
+-+
|  4472  |
+-+

The above query returns a binary format of the substring position of the string Drill.