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.