Re: Help with DECODE

The following SQL statement would work :

SELECT id, type, decode(5.5, least(magnitude, 5.5), 'very faint', 'faint') FROM astro;

(You can use either GREATEST or LEAST function in your query,   depending on the requirement)

Good luck!
- Srini Viswanathan Received on Wed May 06 1998 - 17:43:25 CDT