You could also do a DECODE in the SQL Statement itself. Something like: SELECT PO."NUM", CUSTOMFIELDVIEW."INFOFORMATTED", CUSTOMFIELDVIEW."CFTABLEID", CUSTOMFIELDVIEW."CFNAME", PO."ID" AS PO_ID, PO."VENDORCONTACT" AS PO_VENDORCONTACT, CUSTOMFIELDVIEW."CFSORTORDER" AS CUSTOMFIELDVIEW_CFSORTORDER, CUSTOMFIELDVIEW."CFID" AS CUSTOMFIELDVIEW_CFID, CUSTOMFIELDVIEW."CFDESCRIPTION" AS CUSTOMFIELDVIEW_CFDESCRIPTION, CUSTOMFIELDVIEW."CFTYPEID" AS CUSTOMFIELDVIEW_CFTYPEID, CUSTOMFIELDVIEW."CFREQUIRED" AS CUSTOMFIELDVIEW_CFREQUIRED, CUSTOMFIELDVIEW."INFO" AS CUSTOMFIELDVIEW_INFO, CUSTOMFIELDVIEW."RECORDID" AS CUSTOMFIELDVIEW_RECORDID DECODE(Customfieldview.cfsortorder,'2','APPROVED','') FROM "CUSTOMFIELDVIEW" CUSTOMFIELDVIEW INNER JOIN "PO" PO ON CUSTOMFIELDVIEW."RECORDID" = PO."ID" WHERE (((CUSTOMFIELDVIEW.CFTABLEID) = 397076832)) and Customfieldview.cfsortorder = 2 and po.num = '10010'