>Terrific! So, we just need to add OR IsNull(ccategory_description) part.
>
>Haven't thought about it.
>
>Thanks again for your sharp brain < g >
>

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 )