Skip to Content

PLD - Formula to get last 3 characters

Hi,

What is the formula to get the last 3 characters of a field?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    May 17, 2017 at 08:30 AM

    Sorry... just Substring(F_XXX, F_YYY) where F_XXX is the source field & F_YYY is Length(F_XXX) - 3

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 07:58 AM

    Try: Substring(F_XXX,0,Length(F_XXX)-3)

    Regards,

    H.

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 08:00 AM

    I tried this, it truncate last 3 characters. But, what i need is to display last 3 characters.

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 08:25 AM

    For example, in the CardName

    SELECT right(T0.[CardName],3) FROM OCRD T0

    Add comment
    10|10000 characters needed characters exceeded