create table t1(c int); insert into t1 values (1),(2),(3); select * from t1 where c>'' ; --get nothing(empty result) select * from t1 where c<''; --get result set:1,2,3
create table t2(c char); insert into t2 values (1),(2),(3); select * from t2 where c>''; --get correct result set: 1,2,3 the only difference of t1 and t2 is the column data type: int vs char _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
