List:General Discussion« Previous MessageNext Message »
From:wang shuming Date:March 2 2010 4:10am
Subject:5.1.42 community version select ordno>=' ' error (2)
View as plain text  
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

Thread
5.1.42 community version select ordno>=' ' error (2)wang shuming2 Mar
  • Re: 5.1.42 community version select ordno>=' ' error (2)Dan Nelson2 Mar