sql server通配符处理样例

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