use Case When, Like operator, Where clause

[murthy51162]

Hi
I want to use the Like Operator and Case When operator in Where clause. The situation is like this :

I have a table with Sales_Team_name and Channel. The channel include A, B, C and Sales_Team_name include X, Y, Z. All the sales_team_name can be in all the channels. My requirement is I want all the sales_Team_name of channel A, B but I do not want sales_team_name Z in channel C.

Hope the requirement is clear. Please help.

 

[SQLBill]

How about:

SELECT channel, sales_team_name
FROM tablename
WHERE channel IN ('A', 'B')

-SQLBill

Posting advice: FAQ481-4875