how to replace null values using ASP

hi,

pls guide me how to replace null value with zero for numeric & empty string for strings in SQL using ASP.

thanks & regards

waiting for your reply.