Hi All,

I have a table in SQL Server2005 with a salary field which contains data like:

datatype = text

Salary
------
$24000.00
$21,500.00
$8800.00
$23000.00
$15,900.00


I want all the datas to be uniform and be separated by ',' at the thousands place. Can anyone suggest me a SQL query or statement where I can do this.

Got really stuck ! Any help would be appreciated!!!

First alter your datatype to VARCHAR.