thanks it works in the select clause but what if i
want
it to be included in the group by clause

for example

my column is an integer and i want to group the
results by the cast(column_name/100 - .5 as integer)

how can i do it

thanks


--- Daniel Achermann <ac.hi@...> wrote:

> Hi
>
> This is a support question so please follow up in
> IB-support list in
> yahoo groups.
>
> >if i use floor in 8.98
> >it will return 8
> >but if use int in 8.98
> >it will return 9
> >
> cast(fld - 0.5 as integer) should work I guess or
> you can also write
> your own UDF (user defined function) for floor.
> Details about UDF see in
> manuals or on several interbase pages.
>
> Daniel Achermann
>
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/