Can you please explain little more what kind of output you want?

its not clear.

Kingston Dhasian (6/25/2013)

This is exactly the opposite of what the OP...

@ Kingston Dhasian

i dont think so...

as question says...

selects all orders with zeroes or NULLs in the order_amt field.

so how my query is just reverse?? it will select those orders...

select * from Orders

where isnull(order_amt,0) =0

or

select * from Orders

where order_amt is null or order_amt = 0