Finding the CHARINDEX of last occurrance.

[woogoo]

Hi All,

I need to find the charindex() of the last occurrance of a character within string, but this is proving awkward to solve can anyone help here?
--

woogoo

 

[gmmastros]

reverse the string, get the charindex and subtract from the length of the string. Like this:

Declare @Test VarChar(20)

Set @Test = '123456789101112'

Select Len(@Test) - CharIndex('1', Reverse(@Test))

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom