INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Convert IF statement to CASE statement

Convert IF statement to CASE statement

(OP)
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}

RE: Convert IF statement to CASE statement

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

RE: Convert IF statement to CASE statement

(OP)
Thank You. We are still working on this.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close