CONVERT(VARCHAR(10),CONVERT(MONEY, yourfieldname))
SELECT CONVERT(MONEY,your_varchar_field)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)