SUBSTRB

The SUBSTRB function returns a portion of string, beginning at a specified byte position, and a specified number of bytes long.

To retrieve a portion of string based on characters, use SUBSTR.

Return Value

The return value is the same data type as string.

Syntax

SUBSTRB (string , position [, substring_length])

Arguments

string

A text expression that is the base string from which the substring is created.

position

The position at which the first byte of the returned string begins.

• When position is 0 (zero), then it is treated as 1.

• When position is positive, then the function counts from the beginning of string to find the first byte.

• When position is negative, then the function counts backward from the end of string.

substring_length

The number of bytes in the returned string. When you do not specify a value for this argument, then the function returns all bytes to the end of string. When you specify a value that is less than 1, the function returns NA.

Examples

Assume a double-byte database character set.

SHOW SUBSTRB('abcdefg',5,4.2) 
cd