Right Function Acting Wierd

[#1]

Hello,

I have a really strange behavior with the right function.

im getting a diffrent result than i expected which you can understand more easily by the image i attached..

you can see the diffrent between the value i get in the text box and the value i get in the "TwoRightBud" Field

any suggestions?

[m_woolf · Accepted solution]

In script, use:

text(Right(BUDCODE,2)) as TwoRightBud,

[#3]

Thank you!