Multiple Condition in Case Statement in Sql Server

You Can Use Case Statement Multiple Condition in Sql Server. Fast Response Query. If You are Useful Than comment and Like .

Step 1: Create A Table and Insert Data.

Create table tblTemp (ID int identity not null, NoOfValue int)

    insert into tblTemp (NoOfValue) values ('20')
    insert into tblTemp (NoOfValue) values ('30')
    insert into tblTemp (NoOfValue) values ('150')
    insert into tblTemp (NoOfValue) values ('160')
    insert into tblTemp (NoOfValue) values ('240')
    insert into tblTemp (NoOfValue) values ('678')
    insert into tblTemp (NoOfValue) values ('120')
    insert into tblTemp (NoOfValue) values ('123')

Step 2: See All Recored.

SELECT  *
FROM    dbo.tblTemp

Step 3: See Condition Case Statement.

SELECT  CASE WHEN ISNULL(NoOfValue, 0) < 51 THEN 'Test1'
             WHEN ISNULL(NoOfValue, 0) >= 51
                     AND ISNULL(NoOfValue, 0) <= 100 THEN 'Test2'
             WHEN ISNULL(NoOfValue, 0) >= 101
                     AND ISNULL(NoOfValue, 0) <= 200 THEN 'Test3'
              ELSE 'Test4'
         END AS Value ,
         NoOfValue
 FROM