Category: SQL Server
view more software Tips and Tricks
Updated: 08/15/2014 14:08 PM
Author: Shiju Mathews
Some time SQL server built in function LEN can be tricky.
LEN ( string_expression ) :
Returns the number of characters of the specified string expression, excluding trailing blanks. But the tricky part is that it will count blank spaces in before the given data in the string_expression, but exclude the blank spaces after the data in the string_expression.