>
> > truncate the decimal and you have the integer, subtract them and you
> have
> > the deciaml fraction
>
> I cant find a function to truncate, otherwise i wont ask...
>

it's a UDF - sorry. If you want a non-UDF way then you might have to cast
the result as an integer to truncate it
Alan