SELECT CONVERT(CHAR(2),StoreId) + '-' + AreaId +'-'+ CONVERT(CHAR(2),case when len(PositionId)=2 then PositionId else '0'+PositionId end) + '-' + CONVERT(CHAR(1),FloorId) AS SPName FROM 表名
调试欢乐多
case [PositionId]
when PositionId<10 then '0'+PositionId
when PositionId>=10 then PositionId
end as PositionId
+ '-' + CONVERT(CHAR(1),FloorId) AS SPName FROM 表名
+ AreaId +'-'
+ right('00' + CONVERT(CHAR(2),PositionId) ,2)
+ '-' + CONVERT(CHAR(1),FloorId) AS SPName
FROM 表名