Its not = null It is "is null"

I'm doing this mistake time and again in T-SQL
You should not use = with null, you should always use is null
eg:
WRONG:
EndDate = null
RIGHT:
EndDate is null