I am wondering if it has something to do with the issue of the parameters being varchar() and the columns being char()

If you make the columns varchar does that help ?



>I have proceeded on my research. I can simulate it from SSMS. Basically, it only happens when we pass the values as parameters. If that is the case, I also get a very long process in SSMS. It seems to be a bug when the OR operator is used between two LIKE operators.