Re: column formatting in Oracle

In article <37bkk8$b8t_at_bingnet1.cc.binghamton.edu> bpanko_at_bingsuns.cc.binghamton.edu () writes:
>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.

	Look at the string handling functions.
	They can be used to clean this sort of stuff up.
	(INSTR, INITCAP, SUBSTR, etc.)
	==========================================================
	Chaz Sliger     |     -\     "Let the rough side drag,
	Portland, OR    --\_(HD)\     Let the smooth side show..."
	chaz_at_atlas.com  ()       ()   -Jesse Winchester
	==========================================================

-- 

	==========================================================
	Chaz Sliger     |     -\     "Let the rough side drag,
	Portland, OR    --\_(HD)\     Let the smooth side show..."