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

Reply via email to