Hi Makumbi,
You need to use SQL CASE Statement in your query and check condition.
Please refer below SQL query.
SQL
CREATE TABLE [#Preparedataconvert]
(
[Days] VARCHAR(10),
[Class] VARCHAR(5),
[One] VARCHAR(5)
)
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S1', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S1', '')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S2', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S2', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S1', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S3', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S2', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S1', 'SULK')
INSERT INTO [#Preparedataconvert] VALUES ('Tuesday', 'S1', 'SULK')
SELECT [Days],[Class],(CASE WHEN [One] IS NULL OR [One] <> '' THEN 'Empty' ELSE 'Ok' END) AS [One]
FROM #Preparedataconvert
WHERE [days]='Tuesday'
DROP TABLE #Preparedataconvert
Output
