SQL select records with numeric strings

["Stone, Joel" <Joel.Stone@xxxxxxxxxx>]

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
______________________________________________________________________