We have report which shows the route of a product through production.

Each machine has a work center number that is stored as a string and not a number.

We have a series of tables, that show the Job Steps and these are on the Details section of the report.

PV_JobStep_1 = "001"
PV_JobStep_2 = "526"
PV_JobStep_3 = "221"

all three are separate records/fields and I want to look at all three records and pick the highest, so in this case "526"

Any assistance would be appreciated.