SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

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.