字段缺位时的模糊查找"/>
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
转载于:.html
更多推荐
SQL中字段缺位时的模糊查找
发布评论