theslowturtle
New Contributor II

Hello guys, I'm not sure if you could solve this issue but here is how I've handled it:

SELECT *
FROM my_table
WHERE (CASE WHEN LEN(:my_parameter) > 0 THEN my_column = :my_parameter ELSE my_column = my_column END)

I hope this can help!