Help... Question about SQL Server

[Keiko]

Hi Wen Lie,

Select * from trans_stock where
(pack_no = '') or (pack_no is null)

in case pack_no contains space(s), you may do this ....

Select * from trans_stock where
(ltrim(rtrim(pack_no)) = '') or
(pack_no is null)

Does it help ?

Regards