>SELECT Billing_charges.*, Viscodes.ccode_description; > FROM ; > Billing_charges ; > LEFT OUTER JOIN VisCodes ; > ON Viscodes.ccode_value LIKE ( Billing_charges.crevenue_code+"%" ); > AND Viscodes.ccategory_description LIKE ( "REVENUE_CODES%" ) > WHERE Billing_charges.cbilling_main_fk = ( ?vp_cBilling_main_fk ) >Thanks, looks even better. Let us try it.