Allow if statement to check for empty or null value in a field
I don't see a way for the 'if' statement to check for an empty value. Using 'if field=""' nor 'if length(field)>0' works for an empty text field.
2
votes
Tom Simpson
shared this idea
-
Hello Tom,
Our major release is almost ready. We need to fix some minor problems and it'll be available.
Kind Regards,
Vitaliy Korney -
Tom Simpson commented
Hey, just curious... when will the isnull function be available?
-
Tom Simpson commented
Excellent, look forward to that!! I could use it in my database I created, thanks a bunch!!
-
Hello Tom, it makes sense. We added new function isnull which checks for null or empty value. It will be available in the next release.