Home Forums SQL Server 2005 T-SQL (SS2K5) Find last occurence of a character within a string RE: Find last occurence of a character within a string

  • April 8, 2009 at 7:44 am

    #974281

    You can use the Reverse Function to find the last occurrance.

    Declare @FieldA varchar(100)

    Set @FieldA = 'DirectoryA\DirectoryB\DirectoryC\FileName'

    Select Substring(@FieldA,

    LEN(@FieldA) -

    Charindex('\',Reverse(@FieldA))+2,

    LEN(@FieldA))