Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Experts please help me....
Hi,
you probably need a stored function that does that for you.
this function could use instr() to look for the first blank,
substr the begginning of you text up to that blank and check
the remainder for the right format.
check out the pl/sql manuals for details or post another message if you need more info.
Karsten
In article <3833A6F2.F85AC3B4_at_ti.com>,
norazman_at_ti.com 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 18 1999 - 03:00:28 CST