From: bpanko@bingsuns.cc.binghamton.edu ()
Newsgroups: comp.databases.oracle
Subject: column formatting in Oracle
Date: 10 Oct 1994 14:55:04 GMT
Organization: Binghamton University, Binghamton, NY
Lines: 21
Message-ID: <37bkk8$b8t@bingnet1.cc.binghamton.edu>
NNTP-Posting-Host: podsun2.cc.binghamton.edu
X-Newsreader: TIN [version 1.2 PL2]


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@bingsuns.cc.binghamton.edu