I know this is a popular one and I've Googled it but I haven't found anything that has worked yet, so apologies if this is incredibly obvious.
I'm trying to amend a view to exclude records that are either null or blank in a field called CURRENT_POINT
and CURRENT_POINT is not null
and DATALENGTH(CURRENT_POINT)> 0
The nulls are fine, but I'm still getting the blanks. I hoped DATALENGTH would resolve that but it hasn't.
As I said, I'm sorry if it's obvious. Can anybody advise me please?