Remove zeros from sql stored procedure output

Transact-SQL
1

I am writing somw stored procedure in sql. But i ma gettng some null values as output. so I want to remove that null value records coming as output.

2

Add an additional filter to your WHERE clause.

.....
WHERE
     Column1 IS NOT NULL
     --- your other where filters here.
....
3

Hi
Use this : ISNULL(fieldname,'') <> ''
Cheers