OCTET_LENGTH SQL Function
Syntax
OCTET_LENGTH ( char_expression )
Description
The scalar function OCTET_LENGTH returns the number of bytes in the char_expression.
Example
SELECT NAME FROM customers
WHERE OCTET_LENGTH( name ) < 10 ;
NAME
----
rathan
Dany
2 records selected
Note: SQL-99 and ODBC compatible