How to use between clause in the case statement?

Question

Hello Team,

I am unable to use the below case statement in the where clause. It is saying, incorrect token between. Please see and suggest:

Where [TWPP] = case when [Company]='ABC INC.' then [TWPP] between 91 And 92 else [TWPP] between 89 And 100 end as "TWPP"

and [RNGG] = case when [Company]='ABC INC.' then [RNGG] between 8 And 12 else [RNGG] between 4 And 14 end as "RNGG"

Please help.

Answer 1

I got my answer. I did create 2 CTE and applied case statements while fetching data in the select query.

Thank you all.

Answer 2

Hello Team

No team; this is a community forum with volunteers.

then [TWP] between 91 And 92

Then Between? What for a result do you expect here?

Please describe in clear wods what you are trying to achieve here.