Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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'
Perhaps I may do this WHERE Match("Material Number", 'x', 'y', 'z')
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'
Perhaps I may do this WHERE Match("Material Number", 'x', 'y', 'z')
where match(Material Number,'x','Y','Z')