trim characters off the end of a string

[mikerob283]

Using MSDE server
I have a table with (productid, description, cost)
productid is int
description is varchar
cost is money

but money is adding 2 extra 0's on the end of every entry

thats fine for the database but when i view that in a table in a datagrid I want it to trim the extra 2 00's on the end. sortof like replace(cost, "'", "''") replaces single quotes with two single quotes is there something like that I can use to trim characters?

 

[TPM]

If you set up a table style you could use the column format.

TPM