Simple function
Hi guys,
I have a table with two integer fields (field1 and
field2)...
I would like to construct a function that perform an
operation with this two fiels (field1 + fields2), and
return the string value "A" if the sum is <20, "B" if
the sum is >=20 or <=50, and finally return "C" if the
sum is >50.
So I would do:
"SELECT id,function() FROM mytable;"
and get rows like these:
001 A
002 A
003 C
004 C
005 C
006 B
...
Could you help me???
Thanks in advance,
See ya,
Marcelo
__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/
On Tue, Dec 07, 2004 at 14:49:14 -0300,
MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br> wrote:
Hi guys,
I have a table with two integer fields (field1 and
field2)...I would like to construct a function that perform an
operation with this two fiels (field1 + fields2), and
return the string value "A" if the sum is <20, "B" if
the sum is >=20 or <=50, and finally return "C" if the
sum is >50.
Why not use a CASE statement?
SELECT id,
CASE
WHEN field1 + field2 < 20 THEN 'A'
WHEN field1 + field2 > 50 THEN 'C'
ELSE 'B'
END
FROM mytable;"