trim characters off the end of a string

mikerob283

Member
Joined
Feb 15, 2005
Messages
12
Programming Experience
Beginner
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?
 
Top Bottom