AS/400 backup, AS/400 careers, AS/400 Client Access, AS/400 database, AS/400 DB2, AS/400 errors, AS/400 FTP, AS/400 performance, AS/400 printing, AS/400 Query, AS/400 security, AS/400 upgrading, AS/400 user profiles, CL, CL/400, CLLE, CLP, CPYTOIMPF, DB2/400, DDS, DSPF, i5, IFS, IS-B, iSeries, iSeries database, iSeries development, iSeries networking, iSeries printing, iSeries programming commands, Joblogs, Logical partitions, OS/400, OUTQ, PF/LF, PTFs, RPG, RPG ILE, RPG IV, RPG/400, RPGILE, RPGLE, SAVF, Spool files, Subfile, UDB for iSeries/i5, V5R2, V5R3, V5R4 >>VIEW ALL TAGS
AS400 Qry - Is there a way to trick qry into treating blanks as null?
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?
View Answer
| Apr 23 2008 7:42 PM GMT
| asked by
Sands
AS/400, QRY, Query
Related Member Blogs
System i Blogger
Covering Enterprise System i (AS/400 & iSeries) administration with the latest System i offerings, news, tips & tricks and more.
Views from the P.I.T.
People in IT: Bringing the human element back into the IT profession, by Suzanne Wheeler.
Related content from Search400.com
→ The Mainframe & Application Performance
→ Expert Advice: Copying a physical file back to a spool file
→ Programmer Tips: System i document management tips
→ iSeries Security: New password-control security features for i5/OS V6R1
