I want to be able to use this part without any quotes in the query. It is basically says IS NULL or IS NOT NULL without any quotes on it. How can I achieve this dynamically?
I tried to do it like this but this variable brings quotes around IS NULL or IS NOT NULL:
it shows like this on the overview though:
This basically blocks me from creating dynamic queries.
Welcome to the forum!
This has come up many times and if you search the forum for this topic you will find many responses / solutions
@ScottR , I searched for it but I couldn't find any answers about how I should put the string
without quotes. Do you know any?
It could be that queries are set as prepared statements so that when using that resource you may need to uncheck that box...in the resource...
Or you can try using .replace() on that param