Question

AS400 Qry - Is there a way to trick qry into treating blanks as null?

AS/400, QRY, Query

The data I need to sort on is in either field A or B depending on the transaction type. It could be accomplished by using the "value" expression if qry would consider a blank field as null. Any ideas?

Hello,

This website may be able to help you in your Query...

http://www.itjungle.com/mpo/mpo060503-story01.html

TPinky


One way to do this is a CASE expression.
Beware: not a CASE statement but a CASE expression.
You might have to write it in the ORDER BY clause.