Thanks Lynn

I will do just that for you. I will post it in just a bit

I am able to replace the last pipe, with a different character, I can now...

Yes, that I could. I can use C# in a SSIS package. My problem is that I am not sure where to begin with it.

I am able to replace the...

Thanks Buddy

I was hoping someone may have known of something.

I guess I will stick with doing it the hard way then.

Have a good one.

Andrew SQLDBA

Oops

So sorry about misspelling your name Elliott

Thank You again

Andrew SQLDBA

Thank you Elliot

That works perfectly

Andrew SQLDBA

Oh dang, I cannot believe that I cannot read the SQL BOL.

I think that it may be time for lunch.

I am still missing something. I can get the firstname fine,...

I have tried CHARINDEX, even after replacing the caret with a numeric value, and CHARINDEX is still returning a 0

I replaced the caret with the number 8, which will never...

Thank you Everyone for all the suggestions.

I am going to use the suggestions presented, and then load some data into the database via a .NET front-end, and see how well,...

I just thought of something after I sent the reply.

I can use either SSIS or a SQL job to query the table, and if there are rows in the table,...

Not that I can figure out. This is an old app that should have been done away with decades ago.

I have to use the insert statement within the app, and...

Hey Buddy

That did the trick, thank you so very much.

Andrew SQLDBA

No, Developer Edition is the same as all the others. It only allows a certain number of concurrent connections.

Could be the user was admin on the box, or in the...

Thanks Everyone

Finally this junk is beginning to look like usable data.

Andrew SQLDBA

I just noticed that the sample data that I posted had all the consecutive blanks removed. So my sample did not look correct.

LOL

Andrew SQLDBA

It is not that there are only double spaces, there are many multiple spaces. I guess that I could run that query over and over, eventually it will all run...