I appreciate all of you looking out for me. I am realtively new at this, and I am trying to 1) establish best practices, and 2) get the data that...

Sorry, folks, I didn't mean to cause a stir like this. However, I will learn from this and make sure I specify whether ir not it is for multiple users...

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...

You are right, Lynn. I didn't give you enough sample data. However, I have figured out a way around it. Thank you for your help.

Steve

Lynn,

Thank you very much for the code, and also for correcting what I had sent. This works fine except for one thing; I get this message when I run it:

Msg...

Thanks again. I will look into all of this and incorporate what I can.

Elliott: We want to use DBCC INDEXDEFRAG because we need to be able to do this online and keep the tables available for the users. It also allows us to...

GilaMonster: Yes, this is SQL 2000. Sorry for not clarifying.

Lowell: When I run this code, I get no records.

GSquared, this code smokes! Thanks.

Thanks to you both for your help. I am also going to keep the other code if you don't mind. I might need to incorporate it...

Yes, that will get me started. I should have mentioned that the purchase order numbers may vary in size, as well as the line numbers, which may be from one...

I'm glad I could help out. Thank you all very much for your solutions. As always, it is most appreciated.

Steve

Perfect! Thank you!

Sorry, I'm a little late to respond, I've ben out the past couple of days. All of you have provided a wealth of information and options, plus more reading to...

That worked. Thanks much. You have saved me a bunch of time.

Elloitt,

You are absolutely right. The ERP jobs run through the one administrator user. I did some checking, and I will indeed be able to find the user in the ERP...