Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I'm trying to suggest someone on how best to handle nulls.
In my experience, I have seen that not isnull() works fine but lately, I have seen it behaving weirdly.
So is it safe to say that len()>0 is a suitable replacement for not isnull() in where clauses?
Are there any exceptions/Caveats when with both approaches?
I often use
Len(Trim(FIELD))>0
(or just without the >0 as condition, like If(Len(Trim(FIELD)), THEN ... , ELSE ...)
This also handles empty values / values containing only spaces, i.e. only return TRUE when there is 'something relevant'.
I like using Len(Trim(FieldName)) > 0
I often use
Len(Trim(FIELD))>0
(or just without the >0 as condition, like If(Len(Trim(FIELD)), THEN ... , ELSE ...)
This also handles empty values / values containing only spaces, i.e. only return TRUE when there is 'something relevant'.
Both of you are correct.
I guess i'll award Stefan the correct answer since Sunny's been hogging all the points.
Hahahaha