sqlserver中根据特定字符截取字符串,求大神,特别急,在线等,100财富

发布网友发布时间：2022-04-11 05:14

共2个回答

懂视网时间：2022-04-11 09:35

GOODS_CD AS goodsCd, 原字符串 reverse( GOODS_CD ) AS dCsdoog, 颠倒 LEFT ( reverse( GOODS_CD ), charindex( ‘-‘, reverse( GOODS_CD ) ) - 1 ) AS tluser, 按符号‘-’进行分割 reverse( LEFT ( reverse( GOODS_CD ), charindex( ‘-‘, reverse( GOODS_CD ) ) - 1 ) ) AS result, 将结果倒过来 CONVERT ( INT, reverse( LEFT ( reverse( GOODS_CD ), charindex( ‘-‘, reverse( GOODS_CD ) ) - 1 ) ) ) AS resultInt 将string转成int FROM PI_DSL_ORDER_GOODS og JOIN PI_ST_ENTRY_GOODS eg ON eg.ID = og.GOODS_ID AND eg.DATA_STATUS = ‘1‘ WHERE 1 = 1 AND og.DATA_STATUS = ‘1‘ AND og.ORDER_ID = ‘484eaa92bf5d43c1bb24625688ea7464‘

技术图片

SQLServer常用个技巧（一）：根据某字符截取后面的字符串，String转int

标签：span join and 结果 from image res serve info

热心网友时间：2022-04-11 06:43

declare @aaa nvarchar(20) ;

select @aaa = substring(
'RREN-PSS-NB-14-25'
,patindex('%-%','RREN-PSS-NB-14-25')+1
,(len('RREN-PSS-NB-14-25')-patindex('%-%','RREN-PSS-NB-14-25')+1)
)
select @aaa = substring(
@aaa
,patindex('%-%',@aaa)+1
,(len(@aaa)-patindex('%-%',@aaa)+1)
)
select @aaa = LEFT(
@aaa
,(patindex('%-%',@aaa)-1))
select @aaa;