It's a start 🙂 Could you post examples of the data in your tables next please? Have a look at this article

http://www.sqlservercentral.com/articles/Best+Practices/61537/ and it'll show you how. As...

As I've said before, please can you post some sample data. It will make it much easier to see where there might be a problem.

I wish I was. It's not installed on this server and neither can I actually install it. I'm doing this direct into SQL Server Agent.

Will not do or does not do?

Could you post some sample data please? It will make it much easier to establish what's wrong if we've got an idea what...

The owner of the job is me and the job is run by svc_xxxxr2Agent. Both accounts have sa access and datareader and datawriter enabled.

It also seems that it's one...

Hi Imran,

welcome to the forum.

Try joining to the General Ledger Table with a LEFT join. That's only a guess mind you. If you go to the link on...

Singer

It should just be O'Gara, there's quite a few names with Name #D in the list as it turns out.

The good news is it appears it's not a...

Eric M Russell (10/10/2014)

---

Speaking of research studies with questionable cause and effect, I see this type of thing all the time on the morning news shows. Below is a good...

Road

I'm not sure your link is right Steve. It takes me to a Beth Schultz article about Big Data and Analytics.

Luis Cazares (10/9/2014)

---

Erin Ramsay (10/9/2014)

---

To avoid results like O'GaraD you're going to have to employ logic such as (possibly):

Any characters that occur BEORE or AFTER an invalid character are also...

+1

I misread the BOL page and didn't see the bit that told me what I was reading about. I just saw a particular line and thought...

Thanks Eirikur and Koen.

I'm going to pursue the CTE approach for the time being I think. The solution Eirikur proposed is close but still returns incorrect characters. There's...

That's a phrase I've seen a lot around here but I wouldn't know one if I was served it for lunch 🙂 Are they something that we can do...