Using expressions w/ DECODE?

I'd like to write a sql statement labeling users to my website as "active", "frequent" or "power" depending on how many times they've logged in. Oracle SQL doesn't have an IF-THEN statement and DECODE doesn't let you use expressions (eg. < 5 logins = 'active user', 5>logins>25 = 'active user', > 25 logins = 'power user'). I was thinking of getting 3 result sets and using UNION to combine them but the query is very expensive. There has got to be a way to do this. Any ideas?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 31 2000 - 00:00:00 CEST