EXCELLENT!!!! Thank you VERY much Flo! Your code to extract the dates worked exactly right! I'll use this as the base for extracting the associated text.

And thank for your added...

Well after scratching my head for a bit as to why the code wasn't working, found out that the source server is SQL 2000. :blush:

Guessing some of these commands are...

Thanks again Flo.....

I may need to take you up on that! The code as is gives me some errors that I am trying to debug now.

Thank you Lowell & Flo.....

I'll work with this code to see if I can't get it to work!

Thank you Dave, Lowell & Tom for your replies.

Here are the answers to your questions:

Dave:

The source table is SQL Server, and the field is TEXT.

Unfortunately there is no common delimeter...