Syntax for a select statement

llheath
Participant V

SELECT(salary exempt[EmpEmail], ([department] = “1153111”), TRUE)

how would I add OR department is 115310 in the above statement?
i want to send to all the salary exempt emails that are in those 2 departments

0 2 129
2 REPLIES 2

HBT
Participant V

I guess you want to do this

SELECT(salary exempt[EmpEmail], OR([department] = “1153111”,[department] = “1153110”), TRUE)

Steve
Participant V

Another alternative:

SELECT(salary exempt[EmpEmail], IN([department], {“1153111”, “1153110”}), TRUE)
Top Labels in this Space