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