octet_length

Return the minimum value in each aggregate

Syntax

octet_length(string_expr)

Arguments

string_expr A character string or an expression returning a character string value.

Description

This function returns the number of bytes contained in the specified string not including the null terminator.

Example

select octet_length("1234567890");
octet_length("1234567890")
                        10

select octet_length(L"1234567890");
octet_length(L"1234567890")
                        20