MSSQL Query - How do I get the last index of the string I'm looking for?

First, let's use a function to locate the word 'sample' in the entire sentence.

// Enter your code here
data = 'Hello World, This is sample code'
result = data.index('sample')

print('result : ', result)

Then you'll get the index where the sample is located If you think about the length of the word "sample" again, It's six letters

Then where is the last word, "e"? Is the index of the sample + the total length of the sample - 1 OK?

There may be a better way, but I think we can find it like this.

Note) Please note that the index starts from 0