| description |
|---|
This section contains reference documentation for the substr function. |
Get substring of the input string from start to endIndex. Index begins at 0. Set endIndex to -1 to calculate till end of the string
SUBSTR(col, startIndex, endIndex)
select SUBSTR('Pinot', 1, -1) AS name
FROM ignoreMe| name |
|---|
| inot |
select SUBSTR('Pinot', 0, 2) AS name
FROM ignoreMe| name |
|---|
| Pi |