Convert IF statement to CASE statement

[capronton]

How would I convert to the IF statement below to a CASE statement? Thanks in advance for any assistance.

If {command.current_route_id} = 103 and {command.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {command.tp_id} = 12790
then 15 else
If {command.current_route_id} = 103 and {command.direction_description} like "*NORTH*" and {@earlyLate} = "Early" and {command.tp_id} = 12782
then 15 else
If {command.current_route_id} = 103 and {command.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {command.tp_id} = 371
then "OnTime" else
If {command.current_route_id} = 110 and {command.direction_description} like "*NORTH*" and {@earlyLate} = "Early" and {command.tp_id} = 303
then 18 else
If {command.current_route_id} = 110 and {command.direction_description} like "*NORTH*" and {@earlyLate} = "Early" and {command.tp_id} = 12763
then 18 else
If {command.current_route_id} = 110 and {command.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {command.tp_id} = 12830
then "OnTime" else
If {command.current_route_id} = 110 and {command.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {command.tp_id} = 307
then 20 else
If {command.current_route_id} = 111 and {command.direction_description} like "*NORTH*" and {@earlyLate} = "Early" and {command.tp_id} = 7319
then 20 else
If {command.current_route_id} = 111 and {command.direction_description} like "*SOUTH*" and {@earlyLate} = "Early" and {command.tp_id} = 12743
then 20 else
If {command.current_route_id} = 103 and {command.direction_description} like "*NORTH*" and {@earlyLate} = "Early" and {command.tp_id} = 12763
then 22 else {@earlyLate}

 

[kray4660]

The general case statement for the first line would look something like this for MS-SQL. Every CASE has to have a corresponding END. I am assuming that you are using this in a SQL Expression Field (something I have never used), it would not work in a command since you have an embedded formula.

case when {command.current_route_id} = 103 and and {command.direction_description} like '%SOUTH%' and {@earlyLate} = 'Early' and {command.tp_id} = 12790 then 15 else ....END

 

[capronton]

Thank You. We are still working on this.