Search
InstantDoc ID
GO

Browse By: Author | Issue

August 29, 2008 07:29 PM

T-SQL 101: The CASE Function

In Lesson 9, learn how to transform data with two types of CASE functions
Rating: (0)
Bill McEvoy
SQL Server Magazine
InstantDoc ID #100152
Executive Summary:
T-SQL's CASE function comes in two types: simple and searched. Simple CASE functions examine an expression and compare it to a list of expressions. If a match is found, T-SQL returns a specified result. Searched CASE functions examine a set of Boolean expressions. If a Boolean expression evaluates to true, T-SQL returns a specified result.

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Try to copy and paste BOL next time! I got a better idea: write an article about copy and paste.

MarcosGalvani 4/16/2009 11:08:57 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.