In a query (or in any SQL statement containing an embedded
SELECT statement), you can use bracket ( [ ] ) symbols to specify
that only a subset of the data in a column of a character data type
is to be retrieved. A column expression that includes brackets to
signify a subset of the data in the column is known as a column
substring.
The syntax of a column substring is as follows.
Notes:
1 See HCL OneDB™ Guide to SQL:
Syntax.
Element
Description
column
Identifier of a column within a database table or view
first. last
Positions of the first and the last byte of the retrieved substring
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.