SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004

8-26

Examples of CHAR_LENGTH

•

The PROJDESC column in the PROJECT table has data type VARCHAR(18). This

function returns the actual length of the column value—not 18 for shorter strings—

because it is a VARCHAR value:

SELECT CHAR_LENGTH (projdesc)

FROM persnl.project;

(EXPR)

----------

--- 6 row(s) selected.