I want to tag back the data

[Paknanarn23]

I want to tag back the data of workorder_Inner with R_WORK_LOT ignoring the last 3 characters

[MayilVahanan]

Hi

If you want to ignore the last 3 character, try like below.. its one of the way 

=Left(R_WORK_LOT, Len(R_WORK_LOT )-4)

[Mark_Little]

Hi 

Can you share an example out of what you are trying to achieve as i am not sure what you mean by tag back.

My best guess would be a Concat something like the Below

workorder_Inner &'+'&LEFT(R_WORK_LOT, LEN(R_WORK_LOT )-3) AS "New field"

[Paknanarn23]

No, I need data that the last 3 digits are not -000

[Paknanarn23]

No, I need data that the last 3 digits are not -000

[MayilVahanan]

Are you looking some thing like below

if(right(R_WORK_LOT,3) <> '000', R_WORK_LOT)