| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Experts plese help me..
One way that you can do this is with a cursor. Loop through all the
records and for each one, check to see if it contains CP# and if it
does, perform a select and substring out the part that you want stuffing
appropriate info into a temp table.
Darren
Norazman wrote:
>
> Hi all,
> I have a description field which user use to enter some description.
> However due to bad design (from the earlier designer), I need a way of
> how I can figure this out.
>
> This field can contains any words but usually it was also use to key in
> some Capital number.
> It might be something like this:
>
> CP#4599 ACERPOWER 4100, 64MB SDRAM DIMM(upgradable to 384MB)
>
> However, I'm only interested on the Capital number not the nonsense
> word.
> Normally the format (the way usr keyed) in is 'CP% 999999'.
>
> The problem is, the numbers of record is so huge that I don't want to go
> through it 1 by 1.
> How can I do a SQL to return only whatever from this field that sounds
> like 'CP% 999999' and if nothing match just
> return N/A or whatever to indicate the search string is not exist.
>
> So far I can say around 65-70% of the field have this string.
>
> Thanks for your help.
>
> Azman
--
 |
 |