jaguil1023 (8/1/2008)

---

Jack - Thanks for catching the missing END in the statement. It works fine for positive values however the negative values are returning different results. For example...

Jack - Thanks for catching the missing END in the statement. It works fine for positive values however the negative values are returning different results. For example -10.65...

Jack - Thx your code does what I am looking for however I cannot use it in an update statement

update Table

set Price2 = REPLICATE('0', 11 - LEN(REPLACE(CONVERT(VARCHAR(38), CONVERT(DECIMAL(38,3), Price)), '.',...