LEN
Len is a function which returns the length of a string. This is the most common and simplest function that everyone use. Len Function excludes trailing blank spaces.
SELECT LEN('SMITH IS WRITING THIS')
This will output 21, it is same when we write LEN('SMITH IS WRITING THIS ') as LEN doesnt take trailing spaces in count.
Len is a function which returns the length of a string. This is the most common and simplest function that everyone use. Len Function excludes trailing blank spaces.
SELECT LEN('SMITH IS WRITING THIS')
This will output 21, it is same when we write LEN('SMITH IS WRITING THIS ') as LEN doesnt take trailing spaces in count.
No comments:
Post a Comment