TechNet
Products
IT Resources
Downloads
Training
Support
Windows
Windows
Server
System
Center
Internet
Explorer
Office
Office 365
Exchange
Server
SQL Server
SharePoint
Products
Lync
See all products »
Evaluation Center
Learning Resources
Microsoft IT Camps
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
Solution Accelerators
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Networking
Cloud and Datacenter
Security
Virtualization
Service Packs
Security Bulletins
Microsoft Update
Windows Server 2012
System Center 2012 SP1
Microsoft SQL Server 2012 SP1
Windows 8 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Drivers
Compatability & Converters
Windows Sysinternals
TechNet Gallery
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
TechNet Events
Second shot for certification
Born To Learn blog
IT Camps
Exchange Server
Forefront Server
Forefront Edge Security
Forefront Server Security
Internet Explorer
Office
SharePoint
SQL Server
System Center
Windows Server
Windows XP
Windows Vista
Windows 7
Windows 8
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Microsoft Customer Support
Microsoft Community Forums
United Kingdom (English)
Sign in
Print This Topic
Print Multiple Topics
Home
Library
Learn
Downloads
Support
Community
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Database Engine
Transact-SQL Reference (Database Engine)
Built-in Functions (Transact-SQL)
Logical Functions (Transact-SQL)
CHOOSE (Transact-SQL)
IIF (Transact-SQL)
2 out of 6 rated this helpful
-
Rate this topic
Logical Functions (Transact-SQL)
SQL Server 2012
The following scalar functions perform logical operations.
In This Section
CHOOSE (Transact-SQL)
IIF (Transact-SQL)
See Also
Reference
Built-in Functions (Transact-SQL)
Did you find this helpful?
Yes
No
Not accurate
Not enough depth
Need more code examples
Tell us more...
(
1500
characters remaining)
Community Additions
ADD
.png)
