• Toby,

    Thanks so much for the quick response.
    I tried your excellent suggestions and found that the 2nd approach using REPLACE fixed my problem perfectly.
    I have found your script to be extremely helpful in a task I am involved in where we have changed naming conventions and I needed to find references in procedures using linked server connections.

    Thank you again for sharing your code and for your additional help.

    Lee