镀锌钢绞线-1*7-4.8 怎么取得右边第一个'-'后面的数据字

Question

镀锌钢绞线-1*7-4.8就是得到4.8镀锌钢绞线-1*7-4.8934
就是4.8934-后面位数据不定

Answer 1

declare @s as varchar(100)
set @s = '-1*7-4.8'select reverse(left(reverse(@s),charindex('-',reverse(@s)) -1))/*
                                                                                                     
---------------------------------------------------------------------------------------------------- 
4.8（所影响的行数为 1 行）
*/

Answer 2

declare @s as varchar(100)
set @s = '-1*7-4.8'
/*
                                                                                                     
----------
4.8（所影响的行数为 1 行）
*/select reverse(left(reverse(@s),charindex('-',reverse(@s)) -1))set @s = '-1*7-4.8934' 
select reverse(left(reverse(@s),charindex('-',reverse(@s)) -1))/*
                                                                                                     
--------
4.8934（所影响的行数为 1 行）
*/

Answer 3

select reverse(substring(reverse('-1*7-4.8'),0,charindex('-',reverse('-1*7-4.8'))))

Answer 4

declare @s as varchar(100)
set @s = '-1*7-4.8'
select reverse(substring(reverse(@s),0,charindex('-',reverse(@s))))
set @s = '-1*7-4.8934'
select reverse(substring(reverse(@s),0,charindex('-',reverse(@s))))

Answer 5

declare @s as varchar(100)
set @s = '-1*7-4.8114'
select right(@s,charindex('-',reverse(@s))-1)
/*
----------------------------------------------------------------------------------------------------
4.8114(1 行受影响)
*/

Answer 6

declare @s varchar(100)
set @s='-1*7-4.8'
select reverse(left(reverse(@s),charindex('-',reverse(@s))-1))