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

  • June 17, 2009 at 12:58 am

    #1010662

    shiwani2002sg (6/17/2009)

    i wish to extract last 3 characters of a string, in sql server 2005,.

    substring doesnt accept -3 as length. so plz suggest some way

    ex helloALL

    output : ALL

    Select RIGHT('helloALL',3) will give 'ALL'.


    Pradeep Singh