title: make blank row appear 0 in ms sql
body: <p>I have a table containing Remarks as a column. Now i have to display the data inside remarks as 0 if the row is blank i.e empty but not Null. Please give me a query that will solve my problem in MS SQL server 2005.</p>