C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Using case statement in SQL server

Posted Date: 23 Apr 2008 Resource Type: Code Snippets Category: SQL

Posted By: DhivyaSelvadurai Member Level: Gold
Rating:

Points: 5

Using Case statement in select query to get the required data


								
USE DATABASENAME
SELECT Sno,CASE WHEN Age>=25 THEN 
UPPER(Firstname+SPACE(1)+Lastname) ELSE LOWER(FIrstname+ SPACE(1)+Lastname) END,
Designation FROM Table1

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: List user-defined procedures
	Previous Resource: Replacing a string with Null value in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

Help Desk