Instead of using expensive REPLACEs, you could always convert it to the MONEY datatype and then to DECIMAL.  The MONEY datatype takes commas in stride.

I'm glad that someone else still likes SQL Profiler. 😀

As for that 10-15% CPU thing?  The only time I don't cringe at that is when a large batch...

Interesting... earlier today, I ran the following code and it said "Error near ONLINE" and would not execute.
ALTER TABLE dbo.Trans
ADD CONSTRAINT PK_Trans PRIMARY KEY CLUSTERED ([Iterator]) WITH (ONLINE =...

Heh... Crud.  It turns out this is a moot point.  They don't want "just" a Not Null column with a Unique Clustered Index... they actually want a Primary Key CONSTRAINT...

Heh.... I was trying to avoid that because 1) I don't have any other HEAPs, 2) I didn't want to take the time to make one, and 3) the reason...