Tag Archives: Blanks in Data

SQL using case to Identify blanks vs NULLs

Posted on 04/27/2012 by eSearing

I had a strange issue driving me nuts today. I had data with null values and could use isNull to capture most of them and assign a new value to the field. However about 10 records would not accept the … Continue reading →

Posted in Code, Snippets, SQL | Tagged , , , | Comments Off on SQL using case to Identify blanks vs NULLs