SQL Server Character Processing (LastIndexOf usage), STUFF, CHARINDEX, REVERSE, LEN, charindex

SQL Server Character Processing (LastIndexOf usage), STUFF, CHARINDEX, REVERSE, LEN, charindex
DECLARE @ s VARCHAR (100)
SET @ s = 'r1-1-1 'Get the number after the last "-"
Select REVERSE (@ s) Return Value: 1-1-1R reversed characters select LEN (@ s) Return Value: 6 get length select CHARINDEX ('-', REVERSE (@ s) return value: 2 -- Obtain the position where a string appears for the first time. If no character is changed, 0 select STUFF (@ s, 1, LEN (@ s)-CHARINDEX ('-', REVERSE (@ s) + 1, '') Return Value: 1
STUFF function STUFF (expression, start, length, relaceChar) expression: the start position of the string to be processed (by the way, the SQL Server starts from 1, not 0)
Length: number of characters to be replaced relaceChar: Replace the selected character with xx