sql server通配符处理样例

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)
*/