declare @tempStr as varchar(29) set @tempStr = convert(varchar(29), convert(money, Amount), 1) select left(@tempStr, len(@tempStr) - 3) as Amount
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)