>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 ) >The View designer doesn't take it :(