I have imported a CSV file into the database and i want to write some functions to ensure that when data is loaded in that all spaces are removed from certain columns.
For Example: In the Phone No column the numbers can appear as follows 07712345678 077 1234 5678 077 12345678 077 12 34 56 78
I want to remove all spaces from the column and have been trying to use the following query;
SELECT replace(PHONE_NO,' ') FROM IMPORTED_DATA_TABLE
However this displays all the results correctly in the results pane, but i want to update the column to remove the spaces. Could someone point me in the right direction or am I going about this the wrong way?