WHERE clause for multiple values

[Drece-gkn]

Hello I have an app that I am making adjustments to. In the script we have a Where clause that says WHERE "Material Number" = 'x' (Made up material number as I can show those). I want to change this to include more Material Numbers. So I want the clause to say WHERE "Material Number" = 'x','y','z' but commas give me an error. What is the proper way to write this clause?

[Clement15 · Accepted solution]

Hello,

I don't know if this is the most optimized way, but you can do this.

WHERE "Material Number" = 'x' or "Material Number" = 'y' or "Material Number" = 'z'

[Anil_Babu_Samineni · Accepted solution]

Perhaps I may do this WHERE Match("Material Number", 'x', 'y', 'z')

[anat]

where match(Material Number,'x','Y','Z')