On 11/8/2012 8:49 PM, YAN HONG YE 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
It's not NULL, it's an empty string. Run these statemetns, see for yourself:
SELECT fmn,IMPLANTATIONgrading FROM T93C_ADL WHERE IMPLANTATIONgrading
!= '' and fmn like '85495%';
SELECT fmn,IMPLANTATIONgrading FROM T93C_ADL WHERE IMPLANTATIONgrading =
'' and fmn like '85495%';
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users