Subject How to use the floor function in MS SQL in Interbase
Author Allan Morris Caras
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/