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?
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?