I am trying to update selected data from a table column and format this data as currency.
My table column holds strings that have both mixed whole numbers and already formatted data. This was due to the fact that I had migrated old data which were whole numbers but any new data or updated old data gets formatted correctly in the application and database.
I would like to select all the non-formatted data from this table column and then Update this data to currency format. 0 to 0.00, 200 to 200.00, 23702 to 23,702.00, 34000.00 to 34,000.00, 2954795.54 to 2,954,795.54
Any assistance would be highly appreciated.