On 9 November 2012 01:49, YAN HONG YE <yanhong...@mpsa.com> wrote: > sqlite> SELECT fmn,IMPLANTATIONgrading FROM T93C_ADL WHERE > IMPLANTATIONgrading i > s not null and fmn like '85495%'; > 854954|R > 854952| > //-----------------------------------------------------------------here is > NULL, but I don't know why it shows in the not null result
What you are claiming is null is an empty string; they are not the same thing. > 854951|R > 854953|R > 854950|R > 854959|G > 854957| > 854955|R > 854956|R > 854958| http://en.wikipedia.org/wiki/Null_(SQL) Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users