MOD is a MySQL function. In this case you do actually need to use the % operator. But PAD reserves % as the character for variable notation. So, you need to escape it. The correct way to escape % is to use %%. So, try this:
SELECT [NUM]
FROM [%str_sheetName_Num%$]
WHERE [NUM] %% 2 = 0
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
