Re: So what's null then if it's not nothing?

Rats! I just read that the ANSI standard says NULL is char(0)! That's probably why some Pick/MV implementations use char(0) as an end-of-record marker - becuase that fits more with what the ANSI standard goes on to say about NULL-terminated fields. So SQL is wrong (confuses NULL (nothing) with UNKNOWN (maybe NULL, maybe something else)) and ANSI is wrong too (char(0) is not nothing)! Phew - thank God for Pick!

Mike. Received on Fri Nov 18 2005 - 03:20:50 CET