Use SQL string inversion function reverse to implement LastIndexOf function skillfully

To achieve a simple business:

Use the SQL script to get the ' 61970b0101.jpg ' part of the string ' large/020700/61970b0101.jpg '.

The first thought is in C # LastIndexOf, but there is no such function in SQL, only the CHARINDEX function, we have to use the existing resources to solve the curve.

Solution Ideas:

1. Use the reverse function to invert the string

2. Use Charindex to find the first place to appear '/'

3. Use the Left function to find the string before '/'

4. Use the reverse function again to reverse the processed string

Specific examples:

DECLARE @Str VARCHAR (50)

SET @Str = ' large/020700/61970b0101.jpg '

SET @Str = REVERSE (@Str)

SET @Str = Left (@Str, CHARINDEX ('/', @str, 0)-1)

SET @Str = REVERSE (@Str)

SELECT @Str

Done!

Use SQL string inversion function reverse to implement LastIndexOf function skillfully