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