If/Then Statement 2

[Meg09]

Hi,

I am trying to write an if/then statement. I have a code that is five digits long. What I want the formula to do is if the last digit of the code is a '1', then I want the word 'Manager' in my report. I tried the following:

if {emp_person.distribution_code} = 'xxxx1' then 'Manager'

Any suggestions would be appreciated. Thanks!

 

[lbass]

if right({emp_person.distribution_code},1) = "1" then
"Manager"

This assumes that the code is a string.

-LB