Home Forums SQL Server 2005 Administering extact last 3 characters from a string RE: extact last 3 characters from a string

  • June 20, 2009 at 1:49 am

    #1012769

    select substring(srcString, charindex(targetString, SrcString),len(srcString)-charindex(targetString, SrcString)+1)

    This is a generic statement to be used in place of Right() where srcString is the main string and targetString is the string to be found from srcString.


    Pradeep Singh