Dear All...

I have a simple question...
I want to make a query like below :

Select * from trans_stock where pack_no = ''

(I want to select all field from trans_stock table where pack_no is empty / NULL).

But the problem is after I ran it, the result has failed.
Actually, if my query runs well, it will result 3 records...
But, after i run my SQL statement above, it shows that the result is 0 Record...

My question is, how can i select all fields from trans_stock table where pack_no is empty or NULL ???

Thx...

Wen Lie