need to round but have no round function

[sqlmystery]

I need to round a number in a birdstep database in a sql script, yet I receive an error message that round is an invalid function.

Is there a way to get around this?

The main issue here is for some reason the db folks put the int part of a number in one column and the float part into another column (but in int form). For instance 140.44 put was put into 2 columns in db as 140 in one column and 439999999 into another column. I now need to get 140.44 to come back out again but truncate and round do not seem to be supported. Any suggestions?

Thank you for any help.

[nosepicker]

What rdbms are you using?

[sqlmystery]

we're using Birdstep in QNIX and MS Access to Access db in windows environment, but scripts are run in QNIX w/ Birdstep