Remove Spaces From VARCHAR2 Using REPACE Function

[dwayned]

Hi Guys,

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?

thanks
Dwayne

[dwayned]

Hi Guys,

Sorry I figured out how to update as below;

UPDATE IMPORTED_DATA_TABLE SET phone_no= replace(phone_no,' ');

thanks anyway.
Dwayne