SUBSTRING
The SUBSTRING function returns a new character string that is a substring
of another string. The new string begins at the specified starting point
in the original string (string1) and extends the number of characters
specified in the length parameter. If the length parameter is omitted,
the new string extends to the end of the original string.
The return data type is C STRING.
Syntax
SUBSTRING(string1 FROM start [FOR length]))
string1
Required. This is the string that contains the characters that will be
returned.
FROM
The FROM keyword is required.
start
Required. start is an integer indicating the position of the first character
relative to 1 that will be returned.
FOR length
Optional. This indicates the number of characters after and including
the start character, that will be returned. If omitted, all of the remaining
characters after and including the start character will be returned.
Example
SUBSTRING(PRODUCTS.PRODUCT_NO FROM 2 FOR 3)
The character position index begins with 1. If the product_no is ASUP93541,
the above example would return SUP.
select product_no,
SUBSTRING(PRODUCTS.PRODUCT_NO FROM 2 FOR 3) as Sub1,
SUBSTRING(PRODUCTS.PRODUCT_NO FROM 5) as Sub2
from products
Product_No |
Sub1 |
Sub2 |
ASUP93541 |
SUP |
93541 |
BPRI54687 |
PRI |
54687 |
Top
|