I have empty fields in my table and i need to check for this and return another value. ISNULL and COALESCE checks for nulls only. I found this:
SELECT * FROM tbl WHERE LTRIM(RTRIM(ISNULL(fieldName'')))=''
but i didnt know how to put it in my select statement to return another value than an empty string.