searching for numeric string in character data

[Elliott]

Hello, 

I need some help with transactional data and I am not sure where to begin.

I need to search transaction data in a comments field for a numeric string (Account Number).

I have a data set with multiple rows with a unique id and time stamp to group all records together a chat transcript.

I need to pull the account number from the comments field without knowing what it is.  I only know it will be 16 digits.  The client may have entered it all in one string or it could be like xxxx xxxx xxxx xxxx.  Hopefully there is no other way.  

Can anyone assist me with this?

Thanks in Advance.

Elliott

[ChrisNZ]

One way:

where prxmatch('/\d{16}/',compress(COMMENT,' '));

This looks for 16 digits in a string where spaces are removed. Suitable?