select * from ( select 'WLMSADC_ADJ20130908.txt' as FileName union all select 'WLMSADC_ADJ20130906.txt' as FileName union all select 'WLMSADC_ADJ201309062.txt' as FileName ) a where FileName like '%WLMSADC_ADJ%' and FileName like '___________________.txt' /*result FileName ------------------------ WLMSADC_ADJ20130908.txt WLMSADC_ADJ20130906.txt (2 row(s) affected) */ select * from ( select 'WLMSADC_ADJ20130908.txt' as FileName union all select 'WLMSADC_ADJ20130906.txt' as FileName union all select 'WLMSADC_ADJ201309062.txt' as FileName ) a where FileName like '%WLMSADC_ADJ%.txt%' /*result FileName ------------------------ WLMSADC_ADJ20130908.txt WLMSADC_ADJ20130906.txt WLMSADC_ADJ201309062.txt (3 row(s) affected) */