This shows you the differences between two versions of the page.
— |
substring [2015/09/23 20:27] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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 |