You can do such task with the Firebird UDF, but it will work only with
Firebird.

C.

> -----Original Message-----
> From: Allan Morris Caras [mailto:amscaras@...]
> Sent: Miércoles 8 de Agosto de 2001 2:42
> To: IB-Architect@yahoogroups.com
> Subject: [IB-Architect] How to use the floor function in MS SQL in
> Interbase
>
>
>
> Hi,
> Our company is currently porting all our windows
> applications into Linux applications. My problem in
> interbase is how to use the floor function in MS SQL
> in interbase.
> The floor function is used to get the whole number
> whenever there is a decimal place.. for example
> if i use floor in 8.98
> it will return 8
> but if use int in 8.98
> it will return 9
>
> i tried to use cast but it always try to convert it to
> rounded whole number...
>
> any help will be appreciated thanks
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
>
> 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/
>
>
>
>