srodgers45
asked on
Give NULL value a name in SQL View
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the quick response. It worked...
SELECT blah, blah, blah, ISNULL(column_name, 'Not Entered') as column_name
FROM your_table
COALESCE can also be used if you want to pull this off using more than one column, but for your question above ISNULL works.