5.1.42 community version select ordno>=' ' error (2)

[wang shuming]

Hi,

  Any table with a ordno char(n)  not null  field

for example

ordno     qty
             35
               0
               1
'abc'         3
'000'     100

select * from table1 where ordno>'   ' or ordno='   '
> 5 rows

 select * from table1 where ordno>='   '
 > 2 rows

best regard!
Shuming Wang