How to add case statement to this 1

[pectin232]

How to add case statement to this:

Replace({Command.ROLE}, "_", " ")

Like if {Command.ROLE} = 'test' then
{Command.ROLE} = 'ANALYZE' else 'NA'

.... there are like 100s of them...

 

[lbass]

select replace({command.role},"_","")
case "test" : "ANALYZE"
case "abc" : "SOMETHING ELSE"
default : "OTHER"

If there are hundreds of options, I wonder if there is another approach. Are the results you want coming from another table?

-LB

 

[pectin232]

I think so.. some of the reports do not even have a SQL in command and use just Procs and functions from Oracle. That makes it hard for me to even understand the logic in many ways... as the were all outsourced to many different developers all around India.

 

[lbass]

Okay, then I have no further suggestions.

-LB