Alan, this IS NOT a support list. This list is for discussing design
decisions about IB and FB.
Please take your support questions to the emailing list
ib-support@...
(ib-support-subscribe@yahoogroups.com should be the email address you have
to write a blank message to become a member)
or visit the newsgroups server at news.atkin.com
where the same list is mirrored as a newsgroup.

You already were told one day ago that this is not a support list. Please,
understand.

C.

> -----Original Message-----
> From: Allan Morris Caras [mailto:amscaras@...]
> Sent: Jueves 9 de Agosto de 2001 3:06
> To: IB-Architect@yahoogroups.com
> Subject: [IB-Architect] How can I use a group by when I want to group a
> column divided by 100
>
>
> How can I use group by when I want to use a statement
> like this one:
>
> select cast(column_name/100) from my_table
> group by column_name/1000