Thanks for your reply,

Yeah as you mentioned i have read some article on 2005 , as this is an issue for indexing & Null .

But my major problem is there is huge data i have with NULLs, now i want to tune the queries, such that the query should handle the nulls before sending the result back to UI. Right now i am achieving this by writing the "case" statement for each field like this.

Case when Column1 is NULL then ''

when Column1 is NOT NULL then Column1 end

like this the script is written for all the columns in each table. Which i causing script to increase in 100's lines and also getting difficult to edit/fix any issues

Can any one provide better way to handle this.