PLD - Formula to get last 3 characters

[beehoiphoebe_yeo]

Hi,

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

[former_member207541 · Accepted solution]

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

[beehoiphoebe_yeo · Accepted solution]

Thank you very much! it works!

[gonzalogomez]

For example, in the CardName

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

[beehoiphoebe_yeo]

is PLD, not query.

[beehoiphoebe_yeo]

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

[former_member207541]

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

Regards,

H.