MSSQL中按IN搜索后按IN排序

1.检索项为INT型

SELECT * FROM IEMModels WHERE ModelID IN (7,9,5) ORDER BY CHARINDEX(','+rtrim(cast(ModelID as varchar(10)))+',',',7,9,5,')  

2.检索项为VARCHAR型

SELECT * FROM IEMModels WHERE ModelDes IN ('b','a','c') ORDER BY CHARINDEX(ModelDes,'b,a,c');