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