The INSERT was just for some sample data. I'm not sure if you want to eliminate the NULL values within your SELECT or on client side. If you want to remove the NULLs in your select you can use:

SELECT ISNULL(<AnyColumn>, 'OtherValue')

Greets

Flo