topic Re: WHERE clause for multiple values in App Development

WHERE clause for multiple values

Drece-gkn — Tue, 05 Mar 2024 15:54:15 GMT

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?

Re: WHERE clause for multiple values

Clement15 — Tue, 05 Mar 2024 16:21:38 GMT

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'

Re: WHERE clause for multiple values

Anil_Babu_Samineni — Tue, 05 Mar 2024 16:23:39 GMT

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

Re: WHERE clause for multiple values

anat — Tue, 05 Mar 2024 16:26:15 GMT

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