Subject Re: [IB-Architect] How to use the floor function in MS SQL in Interbase
Author Daniel Achermann
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