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.
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