SQL中字段缺位时的模糊查找

//缺一位 

select top 1 * from PRO_Precisionstretch_Merge where rodno like @rodno+'_' and right(rodNO,1) > 'G' order by rodNO asc

//缺多位

select top 1 * from PRO_Precisionstretch_Merge where rodno like @rodno+'%' and right(rodNO,1) > 'G' order by rodNO asc

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/QiuJL/p/4524251.html