I am trying to use a parameter in SQL to return values > 5 when the parameter is "Yes" and return all values when the parameter is "No" I don't have a good understanding of how to do this. If you know how to do this then please explain the logic behind it.
... WHERE (@Param Is Null Or @Param != 'Yes' Or YourField > 5) ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)