SQLTeam.com | Weblogs | Forums

Remove zeros from sql stored procedure output

sql2016

#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