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

  • October 15, 2009 at 9:45 pm

    #1066672

    ps. (6/17/2009)

    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'.

    I think all the ones after this one are just academic, they show different ways to accomplish the same thing, but THIS is the easiest AND the one he should use. He wants the last three characters.. Bang.. Done.

    CEWII