Limiting the values in List Box

[#1]

Hi All,

If some one can answer this question and help me out, my life will become very very easy.

I have a list box which has values from 0 to 100

For my reporting purpose I just need values which are greater 15

If I use default list box then user has to always select values which are greater 15 manually every time.

Is there a way that I can make a list box which show values like this:

0

1

2

3

.

.

.

14

>=15

Plesae reply if there is any way or any other way/object which can handle this requirement.

Thanks,

TA

[#2]

Yes your answers are very helpful.

Do I have to write this in SQL statment before loading the data?

Can I write it at the end of the sql query?

[MayilVahanan]

Hi

Load if(FieldName < 5, FieldName,if( FieldName <= 15, '>=5<=15', '>15')) as FieldName , *;

     Select * from tablename;

Its useful i think