Glen Parker schrieb:
Ben wrote:
I'm sorry maybe I missed something, but if you don't need NULLs and
feel they just add extra work, why don't you just declare all your
columns to be not null and have them default to zero or an empty string?
Because I DO need NULLS for non text fields, and I still want NULL to
compare equal to, say, '' and 0. I don't think you read what I wrote...
Put another way, I would like to redefine NULL to mean BLANK or NOT
ENTERED. Totally different concept.
Not wise concept, but here you go:
WHERE coalesce(sometimesnull,'') = '' or
WHERE coalesce(sometimesnull,0 ) = 0 ...
Regards
Tino
