Does this check for Null and Blank?


Legendary Poster
Yes mate

Look at this ASCII chart as that's what it boils down to at the end of the day in the 2 CPU registers that ask the question :)

Space is 20 HEX
NULL is 0 HEX (less than blank)
ZERO is 30 HEX (so it's greater than blank ;))

PS: This chart has been printed out and as been up on my desk everywhere I've worked for the last 20 years as I keep forgetting. :)
Last edited:


Legendary Poster
It depends John.

I think Andrew was asking how JDE's ER handles nulls in a comparison.

For example Standard SQL treats NULL values as having no value. A comparison in SQL (and some other languages) returns NULL rather than True or False.

I suspect that JDE ER automatically does NULL conversions to a not-null low value but I've never coded that assumption.