Are you absolutely certain that the users Login was the one that created the database? Could it have been an application login that created the database? I am shocked that...

Lowell

That did the trick, the code that you gave worked perfectly.

Thank you very much to everyone. I greatly appreciate all the suggestions and help from each of you

Andrew SQLDBA

Here is an example of the data that I am working with

<OBX.5><OBX.5.1>HospitalName CityName</OBX.5.1><OBX.5.2/><OBX.5.3> ...

I forgot to mention this, but the column is a text data type, and replace is not working with Text data type.

Andrew SQLDBA

There are hundreds of tags throughout the column, and the tags are not in the same location in each row.

Any advice?

Thanks

Andrew SQLDBA

Yes, I have thought of that. But what I am not getting is all of the number within the tags.

So my data looks like this if there are more than...

Either, it does not matter.

Andrew SQLDBA

Thanks Everyone

That works well

Andrew SQLDBA

Thank You Lowell

But I am not at all sure why you are including all the UNION All statements. And using a CTE method.

I am just after a simple replace in...

Right after posting, I found my copy. I knew that I had that coded already.

Sorry about that, but thank you

Andrew SQLDBA

Works perfectly.

I was missing the -1

Thanks

Andrew SQLDBA

Because our DR box is behind the DR firewall, both boxes have the exact same name, only the IP address is different. I have done this in the past for...

Our DR switch over is automatic. So I need to have both servers the same, and the data up to date.

Andrew SQLDBA

This is part of our website, and we want to be able to store the inventory, and recipes in one single database. Not having to try to keep multiples up...

I would rather store the data as data, so I can query the table to find all recipes that have a certain ingredient or that takes under a certain time,...