How to make cell borders appear when data is null

[mellenburg]

I'm using writing the results of a query to a web page. For the text fields, when there is no data, the cell on the web page has no border. I know I can get around that by making the value of blank cells " ".

Are there other methods that can be used? Is it possible to while reading in the table, change the NULL or "" values to " " in the SQL statement?

 

[swampBoogie]

select case when c is null or '' then ' ' else c end
from t

 

[deeshubby]

if you want to make it Netscape friendly, you may actually prefer to add in a hard coded "non-breaking space"...

looks like this: " "

Which is maybe what was written in the post above and was accidentally turned into an actual space.. so if you already knew this.. my apologies.