>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 )
>