SQL Query to search multiple values in DB

[praneshsapmm]

Hello ,

Can you any one let me know the SQL query to used in Alteryx Query builder to search line items for multiple values on given date . 

I mean for todays date i want search for plant codes A, B ,C at a time .

Thanks

[raychase]

Something like the following?

SELECT *

FROM TABLE

WHERE DATE = GETDATE()

AND PLANT CODES IN ('A', 'B', 'C')