Find position of last occurrence of character

[JayKusch]

Say I have a string of:

R:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf

and I want to know the position of the last \ (which would be position 43).

Thanks!

Thanks

J. Kusch

 

[checkai]

http://www.sqlservercentral.com/scripts/T-SQL+Aids/31116/

 

[gmmastros]

Declare @Test VarChar(100)


Set @Test = 'R:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\model.mdf'

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

-George

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