Saturday, August 1, 2015

SQL tutoail - lesson 19 - len function

If you want to check the length of any particular text field then you use len( ) function

syntax:

select empname, len(empaddress) as length of employee adress from emp;

When you run the above SQL query, SQL will return the length of the employee address.

No comments:

Post a Comment