T-SQL Like

like 'D%' 　　D开头

like '_e%'　　第二个字母是e

like '[ABC]%'　　A或者B或者C开头

like '[A-E]%'　　A-E开头

like '[^A-E]%'　　非A-E开头