Parse A Numeric String From A Field

Hello All,

I'm trying to parse for a numeric string from a column in a table. What
I'm looking for is a numeric string of a fixed length of 8.
The column is a comments field and can contain the numeric string in
any position
Here's an example of the values in the column


1) Fri KX 3-21-98 5:48 P.M. arrival Cxled ATRI #27068935 3-17-98
2) wed.kx10/26 Netrez 95860536


Now I need to parse through these lines and return only the 8 digit
numbers in it
The result set should be


27068935
95860536

This is what I've done so far


Declare @tmp table
(
Comments_Txt varchar(255)
)

Insert into @tmp

select Comments_Txt from Reservation

select * FROM @tmp where Comments_Txt
like ('%[0-9][0-9][0-9][0-9][0-9][0**9]%')

But it returns the entire comments field in the result set. What I need

is a way to return just those 8 digits.

Any Ideas??


Thanks in advance!!!