Thanks for the quick reply!

By downtime I meant must I stop all my insert adapters so that there is no activity on my principal for the time it takes me...

Me too! (WEIRD)

BRACKETS! 🙂

Thank you!

This helped me as well.

Thanks!

It does run longer yes.. but it's a very small db and the report only runs once a week..

Thanks again for the help!!

Thanks for all the help!! you pointed

me in the right direction with the substring and charindex..

The following code worked for me...

DECLARE eRA_Report CURSOR FOR

SELECT originalmessageid

FROM AM

WHERE Messagetype...

Thanks for the help!

This is what I used but it returns everything AFTER the word Industry as well..

SELECT SUBSTRING(routingheader, charindex('funder',routingheader), charindex('industry',routingheader)) AS ROUTINGHEADER

All I need is what is between the two words: funder...

This is what I did but it returns more than what I need...

SELECT SUBSTRING(routingheader, charindex('funder',routingheader), charindex('funder',routingheader)) AS ROUTINGHEADER