select DISTINCT TABLE_NAME 
  from INFORMATION_SCHEMA.TABLES 
 where TABLE_SCHEMA='CCDB' 
      and TABLE_TYPE='BASE TABLE'
     and (TABLE_NAME like 'CC%' or TABLE_NAME like 'BO%' or TABLE_NAME like 'CA%')