I have a stored procedure in SQL Server 2000 that performs a search based on parameter values. For one of the parameters passed in, I need a different
WHERE clause depending on its value – the problem is that the 3 values would be where
IS NOT NULL
ANY VALUE (NULL AND NOT NULL)(essentially no
I'm having some mental block in coming up with the correct syntax. Is this possible to do in one select statement without performing some
IF @parameter BEGIN ... END branching?