Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I use WHERE with NULL to obtain population without null records for chosen field?
Tried where LEN(FIELDNAME)>0 but it is not working with real results.
Thank you in advance.
@Asiolinka try this then
where LEN(trim(FIELDNAME))>0 or not isnull(FIELDNAME)
@Asiolinka LEN(trim(FIELDNAME))>0
Hi,
You can use where (Fieldname) < > 0 in backend
If you need further help, can you share your dataset?
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!
It does not work.
I found 100 nulls (by using IsNull) in one field.
Now I need to find another errors but using population without 100 nulls I found.
Tried LEN/trimLEN -> population still include number of nulls
where (Fieldname) <> 0 population is bigger than this with nulls.
I should have smaller population after excluding Nulls..
Can you share your data table
I am so sorry but I can not show it here.
@Asiolinka try this then
where LEN(trim(FIELDNAME))>0 or not isnull(FIELDNAME)