I have to find the records which contain 6-A, 6-B, 6-C...6-Z. using SQL? I have a table named TABLE_1 and column test which has records in characters like 'AKLJNAAAAAAAIOUHIO', 'PIOJPMBBBBBBBPIO', 'OJPOIDDDDDDDPQP'...

I have to find the records which contains 6-A, 6-B, 6-C ... 6-Z using SQL. 

How can I do that?
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%'
        ...