SELECT LEN(' ') returns zero
Posted on 2006-06-07
I have to supply an output data feed where they want every column to have at least one blank character -- even if it is null. I tried
SELECT ISNULL(aColumnName, '<BLANK>') but to check it out I added a LEN() function and it is returning zero.
NOTE: <BLANK> is just a space character.
I tried variations using the SPACE() function and the REPLICATE() function but it always returns a zero length from my select. How can I get the query to return a blank for null columns?