Not a problem, Jeff. Thanks for calling me on that.

I only want records that end in '_Syteline_HQ_App', so I just did this:

select left(JobName, patindex('%_[0-9]%', JobName) - 1)

from #JobName where JobName like '%_Syteline_HQ_App'

I know it doesn't solve everyone's problem, but it takes care of this one.

However, I just noticed Ninja's_RGR'us post. That code is much better than mine.

Thank you all for everything, and I will remember to contribute more. You all have taught me a lot in a short amount of time.

Steve