Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Query Regarding Case statement on Where

Author  Topic 

aoriju
Posting Yak Master

156 Posts

Posted - 2011-03-28 : 06:30:51

DECLARE @tbl_Test AS TABLE( ID INT IDENTITY(1,1), EMPID INT, NAME VARCHAR(100))

INSERT INTO @tbl_Test VALUES(1,'TEST'),(2,'TEST1') , (3, NULL), (4,'TEST2'),(4,'TEST3')


I want to take
SELECT * FROM @tbl_Test WHERE NAME = CASE WHEN EMPID =3 THEN NAME IS NOTNULL END

How to write this

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-03-28 : 07:04:40
Not quite clear to me the logic that you are trying to implement. Are you trying to select everything where the name is not null? If so,
SELECT * FROM @tbl_Test WHERE NAME IS NOT NULL
Or, if you are trying to pick the name if there is a name and pick the employee id if there is no name, then

select isnull(name,id) from @tbl_Test
Go to Top of Page
   

- Advertisement -