LPAD

lpad ('Hello', 12) -- returns ' Hello' lpad ('Hello', 12, '-') -- returns '-------Hello' lpad ('Hello', 12, '') -- returns 'Hello' lpad ('Hello', 12, 'abc') -- returns 'abcabcaHello' lpad ('Hello', 12, 'abcdefghij') -- returns 'abcdefgHello' lpad ('Hello', 2) -- returns 'He' lpad ('Hello', 2, '-') -- returns 'He' lpad ('Hello', 2, '') -- returns 'He'

`OCTET_LENGTH()`

Length in bytes (octets) of a string or binary value

Result type

INTEGER, or BIGINT for BLOB

Syntax

OCTET_LENGTH (string)

Table 1. `OCTET_LENGTH` Function Parameter
Parameter	Description
string	An expression of a string type

Gives the length in bytes (octets) of the input string.For multi-byte character sets, this may be less than the number of characters times the “formal” number of bytes per character as found in RDB$CHARACTER_SETS.

Note

With arguments of type CHAR or BINARY, this function takes the entire formal string length (i.e. the declared length of a field or variable) into account.If you want to obtain the “logical” byte length, not counting the trailing spaces, right-TRIM the argument before passing it to OCTET_LENGTH.

LPAD

LPAD Examples

OCTET_LENGTH()

`LPAD` Examples

`OCTET_LENGTH()`