After some testing - you should be able to directly change from string to number without using `CAST` or `CONVERT`. Your issue may lie with the commas - testing this now.