The location where SQL Server obtains the last character.

The location where SQL Server obtains the last character.

CHARINDEX ('characters', reverse (field name ))

This means to reverse the field, that is, to retrieve the last position of a character from the back to the front.

Obtain the final position of a string using SQL

Declare @ str varchar (50)
Set @ str = '1-9-3-2'
Select REVERSE (SUBSTRING (REVERSE (@ str), 1, CHARINDEX ('-', REVERSE (@ str)-1 ))

How can I retrieve the right character of the last special character in a string, for example, 10*20*300? How can I get 300?

DECLARE @ aa VARCHAR (30)
SET @ aa = '10*20*300'
-- Take a fixed-length string, such as the 3 characters After *
Select substring (@ aa, LEN (@ aa)-CHARINDEX ('*', REVERSE (@ aa) + 2, 3)
-- Or take all the characters after the last *
Select right (@ aa, CHARINDEX ('*', REVERSE (@ aa)-1)

-- The result is 300.