SQL Server: How to check if the value of returned field is not null -
i have sql statement follows:
select returndate <joins> <conditions> how check if returndate not null?
you can use case is null (or is not null):
select case when returndate null 'it null' else 'it not null' end isitnull dbo.tablename .... if need filter null/not null values can use is not null:
where returndate not null ...
Comments
Post a Comment