With a binary parameter type, you can set the default value by way of a query.
With a text parameter type, there is no default value option.
I have a text parameter in a query that I've made into a function.
When I'm testing changes to the query, I want that parameter to be driven by a query.
Current workaround is that I can swap the parameter out for a query in the table to test, but that breaks the function, so I have to swap back to the parameter before I can use the query again.
Has anyone found any other way around this, or a way of giving the text parameter a default value driven by a query?