Hi

If I've understood you correctly, you are wanting to replace a NULL value in a SELECT statement, try using ISNULL, e.g.

SELECT ISNULL( , 'string')

Have a look at IsNull in books online for more information.

Thanks

-Matt