It is used to find the length of name (text field as EmployeeName in table[employee]).it is also count space between textfields.
EmployeeID
|
EmployeeName
|
1
|
Mayank Dixit
|
2
|
Mona
|
3
|
Purnima
|
4
|
Payal
|
employee
In the above table (employee), we want to return value of textfield
(employeename).
Syntax
SELECT LEN(Column_Name)
AS Name_of_the_expression
FROM table_name;
Example
SELECT
LEN(EmployeeName) AS Length_of_employeename
FROM Employee;
Here Length_of_employeename is a subname (alias) of column.
Output:-
Length_of_employeename
|
12
|
4
|
7
|
5
|
