Does this help ?

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

VALUES

(1,'<name><name1>aht</name1></name>'),(2,'<name>6</name>')

select *

from @tbl

where col.value('(/name)[1]','varchar(10)')='aht'

Thanks Ed. No tricks, though it is the day after...

Below is a sample of the underlying data. Please excuse me if I did not use the correct code, and for the headers not being completely aligned.

Reporting YearReg AreaOrignalAdmissionOrignalDischargeReadmissiondischargedatedays between...

Hello, our server hard disk crashed due to power failure and all the backups were on the hard disk. Before just before it did we had managed to copy the...

Lynn Pettis (10/28/2016)

---

Chris Wooding (10/27/2016)

---

Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking...

Depending on who you ask, if you go around the company eventually you might find most all of it...

And for any outside service that does cleansing, just be mindful about any protected information in your agreements from which you get these addresses. I see no issue with standardizing...

I DID NOT say "Users are entering data", what I said was "We get tables" - meaning these are tables exported from other systems where the limits are not...

As for ongoing maintenance, there is a fancy cliche out there ... something like "machine learning." It means that new codes that are not familiar would get captured by the...

Maybe this helps? It may not look pretty, but it it worked for me given your requirements of removing the final suffix if it is directional and standardizing the street...

Just one item of consideration that I wanted to throw out there. The bookings can change from day to day, since from a business perspective I imagine each booking can...

If you must have all in one row, you can opt for the names of the people on the project to be stored in a XML type column.

To add my two cents, I just finished a good book that has some useful thoughts on the use of source control as the central tool when working with teams...

I just finished reading this book and it opened my eyes some good ways of organizing the flow of code from development to production, with source control as the pivotal...

This is a cross post.

http://www.sqlservercentral.com/Forums/Topic1827737-145-1.aspx

Rather than posting the same thing in multiple spots, people will better serve you better if you help them to help you. In both of...