I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way in MAPFLD. I would be grateful for any suggestions. Thank you in advance, --John We are on V5R2 and OPNQRY sits on one physical file. I need to create/derive a new column if if/boolean or case logic. i sthat possible? Let's call the deired column/field: @NEW. If field A is filled set @NEW = A If Field B is filled set @NEW = B ( making this real simple. A & B are not filled at the same time) Thanks in advance if you have information on OPNQRYF thanks, --John