A newbie query

I have a table t1(name, value).
The entries are (a1, 40), (a2, 233), (a3, 22).

Is it possible to write a query which tells me whether the value is above/below 100.

The output should be :

Name Value Comparison

a1             40           Below
a2             233         Above
a3             22           Below

Thanks in advance. Received on Thu Aug 02 2007 - 15:33:09 CDT