Re-Assigning multiple names

[surad]

How can I include function by re-assigning multiple names?

Currently I have this statements under fullname:

IIF(Trim({TABLE_EMPLOYEE.LAST_NAME})+", "+Trim({TABLE_EMPLOYEE.FIRST_NAME}) = "Edwards, Sam", "Chase, Sam",
Trim({TABLE_EMPLOYEE.LAST_NAME})+", "+Trim({TABLE_EMPLOYEE.FIRST_NAME}))

Thanks,
Yuri

 

[lbass]

Create a formula like the following using a select/case statement:

stringvar name := {Employee.Last Name} + ", "+{Employee.First Name};

select name

case "Peacock, Margaret" : "Chase, Samantha"
case "Suyama, Michael" : "Abramowitz, Les"
case "King, Robert" : "Patterson, Christina"
default : name

-LB