Jonathan AC Roberts - Thursday, October 18, 2018 10:17 AM
Haven't tried this particular set of data but it might be a little faster to simply convert them to the MONEY datatype and then to decimal. The MONEY datatype isn't bothered by commas and valid currency markers.
Of bigger concern might be the fact that once these are converted to decimal, the currency indications will be gone unless other measures are taken.
--Jeff Moden
Change is inevitable... Change for the better is not.