At 08:37 AM 27/05/2003 +0000, you wrote:

>Hello Set,
>
>Well...the ALARM_GRP holds a value 0 to 5 defining different
>alarmgroups. I was grouping the now not working way in the previous
>database that was DBISAM.
>
>Normally they are not changed in between history savings but now and
>then it is and will then mess up the display routines. So I can skip
>it completely or use as You said, a MAX(..) for it.
>
>Hmm...I use MAX(...) for know and dig into SP later on.

Why not use a WHERE criterion with a parameter to pick the alarmgroup you
want, and exclude ALARM_GRP from the output altogether, viz.

SELECT blah
from blah
GROUP BY blah
WHERE ALARM_GRP = ? (or :ALARM_GRP if your programming interface allows)

heLen