column formatting in Oracle

I have a column in a table, which should be looking like this: Campus PO Box 76234

But during data entry we have put all sorts of combinations like: campus po box 76234
Po Box 76234
PO BOX 76234
CAMPUS P.O POX 76234
and so on.

Is there a way to fix this column so that the "number part" stays and the beginning part looks same for all columns as described.

/*with C programming I could get this done, but importing something into only one column, is it possible?*/

I may be missing some easy fixes.

Any suggestions are most welcome.

Internet address is:bpanko_at_bingsuns.cc.binghamton.edu Received on Mon Oct 10 1994 - 15:55:04 CET