[sql-server] How to use If Statement in Where Clause in SQL?

Select * from Customer
WHERE  (I.IsClose=@ISClose OR @ISClose is NULL)  
AND    
    (C.FirstName like '%'+@ClientName+'%' or @ClientName is NULL )    
AND 
     CASE @Value
         WHEN 2 THEN (CASE I.RecurringCharge WHEN @Total or @Total is NULL) 
         WHEN 3 THEN (CASE WHEN I.RecurringCharge like 
                               '%'+cast(@Total as varchar(50))+'%' 
                     or @Total is NULL )
     END

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to stored-procedures

• How to create temp table using Create statement in SQL Server? • How do I pass a list as a parameter in a stored procedure? • SQL Server IF EXISTS THEN 1 ELSE 2 • Stored procedure with default parameters • Could not find server 'server name' in sys.servers. SQL Server 2014 • How to kill all active and inactive oracle sessions for user • EXEC sp_executesql with multiple parameters • MySQL stored procedure return value • SQL Server: use CASE with LIKE • SQL server stored procedure return a table

Examples related to if-statement

• How to use *ngIf else? • SQL Server IF EXISTS THEN 1 ELSE 2 • What is a good practice to check if an environmental variable exists or not? • Using OR operator in a jquery if statement • R multiple conditions in if statement • Syntax for an If statement using a boolean • How to have multiple conditions for one if statement in python • Ifelse statement in R with multiple conditions • If strings starts with in PowerShell • Multiple conditions in an IF statement in Excel VBA

Examples related to where-clause

• Laravel where on relationship object • MySQL Select last 7 days • SQLSTATE[42S22]: Column not found: 1054 Unknown column - Laravel • Conditional WHERE clause in SQL Server • Conditional WHERE clause with CASE statement in Oracle • How to write a SQL DELETE statement with a SELECT statement in the WHERE clause? • MySQL Multiple Where Clause • How to use If Statement in Where Clause in SQL? • MySQL direct INSERT INTO with WHERE clause • MySql Inner Join with WHERE clause