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

2010-03-01 Thread 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

Re: 5.1.42 community version select ordno=' ' error (2)

2010-03-01 Thread Dan Nelson
In the last episode (Mar 02), wang shuming said: 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