Reports 2.5 Question

I am trying to set up a user parameter which works in the following manner:

Provided with a list (Greater, Less, Between)

Then, I want to do this:

Select number, word, fubar
From mytable
where (number > :someotheruserparameter1

       number < :someotheruserparameter1
       number between :someotheruserparameter1 and :someotheruserparameter2)

I've got the parameters set up correctly, but am having troubles setting up the select statement correctly. I tried

Select number, word, fubar
From mytable
where decode(:choice, 'Greater', number > :someotheruserparameter....

etc, but it isn't working.

[Quoted] Any ideas?

Thanks

--


______________________________________________________________________________
To have your e-mail deleted by my reader before I read it please include 
me in your spam distribution list. I only charge $500.00 per byte that 
your e-mail takes up in my mailbox. What a deal!
_______________________________________________________________________________