Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

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

TOCIndex