Conditional WHERE clauses in T-SQL using comparison operators(dotnetzone.gr)
submitted by 
sotirisf(315) 5 years, 1 month ago
Ever had a query where you wished you could be able to specify the operator (equal, not equal, greater than, etc.) for each column contained in your WHERE clause, without having to use ugly string concatenations and the infamous EXEC keyword? Here we'll see an example of how this can be achieved with the use of a plain SQL query together with some CASE statements.
|category: Database
|Views: 660
tags:
comparison operator where SQL Server another
Everyones tags:
Your Tags: