SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-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.