Question: how to check null and empty in sql server?
Answer: If you are using LEN(...) to determine whether the field is NULL or EMPTY then you need to use it as follows: ... WHEN LEN(ISNULL(MyField, '')) < 1 THEN NewValue...