Re: SQL select records with numeric strings

If this is a one-timer, I'd use Rob's suggestion, something like. ... WHERE REPLACE(text_column,'123456789','0') LIKE '%000000000%'

If this is to be repeated, perhaps even frequently, then I'd consider a UDF. Oracle, for example, has a set of Regular Expression functions (REGEXP_REPLACE, REGEXP_COUNT, ... and I find those useful when I'm in that arena; I've been tempted (but not tempted enough, apparently) to create similar function for the i.
++
Dennis
++
"A good storyteller is a person who has a good memory and hopes other people haven't."
-- Irvin S. Cobb




Bravely sent from my Galaxy tablet phone.
++


"Stone, Joel" <Joel.Stone@xxxxxxxxxx> wrote:

I want to see all rows of a text field that possibly contain a bank
account number.

How can I select all rows which contain a numeric string 9 digits long?

For example something like

SELECT * from TEXTFILE where TEXT like '#########'

Thanks!



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.