While DRH is technically correct, it is possible to use coding convention 
to drive a solution ...  trivially:

$ tclsh8.5
% proc x {} {
   return NULL
}
% puts [x]
NULL

for instance:

% proc recode { val } {
   set ret $val
   if { [string bytelength $val] == 0 } {
    set ret NULL
   }
   return $ret
}

% recode "a value"
a value

% recode ""
NULL

There are, of course many reasons why a null string is not equivalent to 
NULL, but for many applications, the differences are moot.

I'm just saying ...

Cheers,
Rob Sciuk

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to