i want to achive the IIF functionality.

example

select
iff(employee.empid is not null,'sdfsdf',iif(employee.deptid is not
null,'dssdf','sdfsd')) as 'sdsd'
from employee

how to solve this.

thank you
vanitha

You 'might' also find the coalesce() function useful. Check in Books Online.



--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Use the more powerful and ANSI SQL compliant CASE construct.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


[quoted text, click to view]