SQLTeam.com | Weblogs | Forums

How to filter out this record type?

This column is called end_date. this is how it is defined. I am using Netsmart myevolv and don't have access to the database itself but via a reporting system they have. How would I filter I don't want records with an end_date. I tried
is null, = ' ' but nothing is working.
end_date Data Type Character Length Numeric Precision Numeric Scale
DBTimeStamp 8 23 3

did you try and and or did you try an or

end_date is null or  = ''

It doesn't like the or. it can do one or the other.

but neither of them are doing the filter

Are they using Date.MinValue for no end date such as 0001-01-01 ? Hard to provide an answer without knowing what the actual content in the data is