Hi Arn,

> I have a field declared as numeric( 9,2 ).
> In it I store hours and minutes:
> eg: 220,30 hours.
>
> All fine.
>
> Now I must multiplicate that field for money field.
> eg ( 220,30 hours * 8,45 euro ).
>
> How to translate 220,30 in 220,50?

You can convert it to minutes ->
.30 = 30 minutes, 30 minutes/60 minutes = .5

> to perform the multiplication?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com