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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Functions supported by SQL Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-06 : 09:44:00
Nithya writes "Is there an equivalent function for Immediate If (IIf) in SQL Server 2000, as we have in MS Access? In other words is there a way to evaluate an IF statement in a SELECT Clause?"

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-09-06 : 09:47:14
Look up the CASE statement in BOL.

*************************
Someone done told you wrong!
Go to Top of Page

TimSinnott
Starting Member

48 Posts

Posted - 2002-09-29 : 00:50:02
Just what I needed to know. :)

Thanks, royv.

Tim
Go to Top of Page
   

- Advertisement -