Include only certain values in script

[evansabres]

In my script, I want to have a condition where I keep only certain values. At the end of my script I have FROM [Data Source......] WHERE(team = 'ABC') and (team = 'DEF')......and this repeats eight more times. The script does not function at that point. Is there a more efficient way to do this>?

[Anonymous · Accepted solution]

try use of match

where match(team,'ABC','DEF','GHI')>0

-> add more conditions

suppose you want not Team = 'ABC' and Team = 'DEF' as Team only can hold one value

[vishsaggi]

Can you explain a little more what you mean by repeats 8 more times, but you are saying in the end of the script you have a where condition?

[neelamsaroha157]

I think another approach could be use of 'Match' function -

Where Match(team, 'ABC','DEF', you can add more values)

Or you can create a variable with Set vTeamVar = your values and use this variable in match function -

Where Match(team, $(vTeamvar))

[evansabres]

Thank you

[evansabres]

Apologies the question wasn't posed better, but was able to receive help. Thank you for your help