Add SSMS Option to show NULL value Differently than 'NULL' text
It would be nice if SSMS could be used to help distinguish between NULL values and the 'NULL' string value. Perhaps show NULL in grey? Just spent 6.5 hours troubleshooting what turned out to be a string 'NULL' inserted by someone rather than NULL, and if it had been clear on the initial query results grid, I'd have found that much more quickly.
In SSMS 2012, the background color is different.
Tested with :
SELECT NULL, 'NULL'
SELECT NULL, 'NULL';
Steven K. Mariner commented
Text output is particularly problematic as there is no color distinction. Would appreciate the idea generating some thought in that direction as well.