substring_index
CASE B.DataType in (‘A’,‘B’,‘C’)
WHEN
B.ShowValue =‘5’
THEN
substring_index(B.Unit,’/’,-1)
when
B.ShowValue =‘6’
THEN
substring_index(B.Unit,’/’,1)
ELSE B.Unit
END Unit
注意::1代表"/“左边的字符串,-1代表”/"右边的字符串
substring_index
CASE B.DataType in (‘A’,‘B’,‘C’)
WHEN
B.ShowValue =‘5’
THEN
substring_index(B.Unit,’/’,-1)
when
B.ShowValue =‘6’
THEN
substring_index(B.Unit,’/’,1)
ELSE B.Unit
END Unit
注意::1代表"/“左边的字符串,-1代表”/"右边的字符串