SQLTeam.com | Weblogs | Forums

Parse out Text

So I am trying to clean up our customer DB. By using just the customer name can I grab certain elements of text in the record. example:

DL Hugley Construction
Hugley Excavation
DBA Hugley Inc.

I'm looking to find the and capture the largest section of text while omitting certain words like 'excavation' and 'Construction'. How could I make that happen?