2 added 13 characters in body; edited title
source | link

Update selected data from same table column as currency

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.

Thanks

Update selected data from same table as currency

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.

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.

Thanks

Update selected data from same table column as currency

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.

Thanks

1
source | link

Update selected data from same table as currency

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.

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.

Thanks