Use LEN Function When Column Contains NULL value + SQL Server

If you are using LEN function in your SQL Stored Procedure ,Key Point which you need to remember.

- IF your column Contains NULL Value

 LEN(ColName)  - your output is NULL  P.S : you can't compare NULL Values with LEN string

- IF your colum contains String.Empty value

LEN(ColName) your output is 0