Re: [SQLDownUnder] CASE STATEMENT

[Peter Busch, Altosoft]

    SELECT MyFinancialPosition = CASE WHEN BankBalance > 0 THEN 'Rich' WHEN BankBalance = 0 THEN 'Neutral ELSE 'Broke' END ......   or   SELECT MyFinancialPosition = CASE BankBalance WHEN > 0 THEN 'Rich' WHEN = 0 THEN 'Neutral ELSE 'Broke' END .....            

----- Original Message ----- From: anthony To: sqldownunder@xxxxxxxxxxxxxxxxxxxxxx Sent: Thursday, March 10, 2005 12:28 PM Subject: [SQLDownUnder] CASE STATEMENT
How do i create a CASE statement in SQL with the same functionaility as this   select case Type case 1         .....some code case 2     .......some code end select   AnthonySto unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net