Experts please help me....

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 Received on Thu Nov 18 1999 - 01:12:50 CST