Returning all null values - only the ones that have not been used

[baxterstockman]

Hello,

I'm trying to separate the values that have been used and the values that are null/have not been used. Can someone give me pointers on how to do this?

Thanks

[ranman256]

Select * from tbl where [fld] is null

Select * from tbl where [fld] not is null