I have to find the records which contain 6-A, 6-B, 6-C...6-Z. using SQL?
Clean, but the naive version* will most likely perform better.

with t(i) as (select 0 union all select i+1 from t where i&lt;25)
select      *
from        TABLE_1 
where       exists (select null from t where test like '%' + replicate(char(ascii('A')+t.i),6) + '%')


*

select      *
from        TABLE_1 
where       test like '%AAAAAA%'
        or  test like '%BBBBBB%'
        or  test like '%CCCCCC%'
        ...