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