Select Case() of Table, may be of help

----- Original Message -----
From: "Rick Debay" <rdebay@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, February 05, 2007 10:53 AM
Subject: [firebird-support] Query help needed


> Given the number 25, I'd like to get the value 'B' back from the
> following (simplified) table:
>
> V1 V2
> -- --
> 10 A
> 20 B
> 30 C
>
> Numbers 30 and above should return 'C', and numbers below 20 should
> return 'A'.
> This should be simple, but I just can't think today.
>
> Thanks, Rick DeBay
>
> Disclaimer: This message (including attachments) is confidential and may
> be privileged. If you have received it by mistake please notify the sender
> by return e-mail and delete this message from your system. Any
> unauthorized use or dissemination of this message in whole or in part is
> strictly prohibited. Please note that e-mails are susceptible to change.
> RxStrategies, Inc. shall not be liable for the improper or incomplete
> transmission of the information contained in this communication or for any
> delay in its receipt or damage to your system. RxStrategies, Inc. does not
> guarantee that the integrity of this communication has been maintained nor
> that this communication is free from viruses, interceptions or
> interference.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>