Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Length functionsUse length functions to determine the length of a character column, string, or variable, or of the value returned by a character expression, or (for CHAR_LENGTH in multibyte locales) the number of logical characters.
LENGTH FunctionThe LENGTH function (also called LEN) returns the number of bytes in a character column, but excluding any trailing blank spaces.

LENGTH Function

The LENGTH function (also called LEN) returns the number of bytes in a character column, but excluding any trailing blank spaces.

For BYTE or TEXT columns, LENGTH returns the full number of bytes, including any trailing blank spaces.

In , LENGTH can also return the length of a character variable.

The following example illustrates the use of the LENGTH function:

SELECT customer_num, LENGTH(fname) + LENGTH(lname),
   LENGTH('How many bytes is this?')
   FROM customer WHERE LENGTH(company) > 10;

The next example calls the function by its other name, LEN;

EXECUTE FUNCTION LEN("www.hcl.com");

The SQL statement above returns the integer value 11.

See also the discussion of LENGTH in the HCL OneDB™ GLS User's Guide.