User Tools

Site Tools

A PCRE internal error occured. This might be caused by a faulty plugin

Sidebar

**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]

substring

====== SUBSTRING Function - PL/HQL Reference====== SUBSTRING function returns a substring from string. **Syntax**: <code language="sql"> SUBSTRING(string, start_pos [, substring_len]) | SUBSTRING(string FROM start_pos [FOR substring_len]) </code> **Parameters:** | **Parameter** | **Type** | **Value** | **Description** | | string | String | Variable or expression | Original string | | start_pos | Integer | Variable or expression | Start position of substring (starts from 1) | | substring_len | Integer | Variable or expression | Length of substring | **Notes**: * If start_pos is 0 then it is treated as 1 * SUBSTRING and [[substr|SUBSTR]] functions are synonyms **Return Type:** String. **Example:** <code language="sql"> SUBSTRING('Remark', 3); </code> Result: 'mark' **Example:** <code language="sql"> SUBSTRING('Remark', 3, 3); </code> Result: 'mar' **Compatibility**: IBM DB2, Teradata and Microsoft SQL Server. **See also**: * [[substr|SUBSTR]] **Version**: * PL/HQL 0.3.11 SUBSTRING FROM FOR syntax added * PL/HQL 0.01 introduced