Monday, 10 October 2011

SAS-SQL- Scalar Functions- LEN()

nThe LEN() function returns the length of the value in a text field.
Syntax:
SELECT LEN(column_name) FROM table_name
Query:
SELECT LEN(EMPname) AS Employee Name FROM EMPtbl1

No comments:

Post a Comment