Hi, select * from t1 ordno qty 1 3 5 'aaa' 18 'bbbbb' 20
select * from t1 where ordno=' ' or ordno>' ' ordno qty 1 3 5 'aaa' 18 'bbbbb' 20 select * from t1 where ordno>=' ' ordno qty 'aaa' 18 'bbbbb' 20 mysql version 5.1.44 still with the bug Best regards! Shuming Wang