Using A Regular Expression In MSSQL 2005 To Find Patterns Buried In A Field Full Of Misc Data

Thanks in advanace for taking the time to read this post.

I am using MSSQL 2005 and have created a function that allows me to use regular expressions in my SQL queries.

My question is I have a pattern buried in a field of misc data that I need to pull out just that pattern and discard the rest of the data.  Here is the Regular Expression I am using

select field1 from table1

where dbo.RegExMatch (field1,'[a-zA-Z]{4}[0-9]{6}[a-zA-Z]{2,4}')=1

This returns all values in the field that match the expression.  What I want to do now is remove all data from the field on the left and right of the expression that does not match the expression.  How would I accomplish this without reading through the 200k+ records and writing rules for every exception I run across?

so I could have Gar  b/a ge 'THE GOOD DATA' m/or1   ba4d da....ta.  All I want to do is return 'THE GOOD DATA'