I have a database field that is the product of a multiply in a sql statement

and it sometimes has 5 or more decimal places. I want to truncate beyond

the 2nd decimal place(###.##). I figured a Ctype to a decimal value would

do that but the four decimal places remain. I found a truncate function but

it only truncates to whole numbers. how can I do the truncation?

Thanks,

G