SQL LEN

LEN function is used to calculate the length of the value of a text field.

SQL Syntax LEN

SELECT LEN (column) FROM table

Example SQL LEN

Given the following table 'orders'

idorderclientprice
1p1HARRY100
2p2CLARK300
3p3THOMSON250

If we know the length of each value in column 'client':

SELECT LEN (client) AS customer FROM Orders

client
5
5
7