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

Pogo

No, it's not just you. Although you're going to have to keep a eye on the Recent Forum Posts...

You give it that long do you Gaz? I'm thinking at least 20 years sooner...

'$' + cast(floor(Price*DollarPrice) as varchar)

This will give you $xx. You won't be able to do any calculations on that though. If you need to do anything...

You could use a Multicast Transform from the derived column. This lets you send the data multiple ways.

The attached image shows what I mean.

I'll be heading back North tomorrow after a very informative five day BI course in London town. I'm not entirely sure whether I'll be more excited to see my...

Felts

Well done Jason and Jack.

Thanks to those of you who had a look over the website for me, particularly Tom and Luis for taking the time to give such helpful...

Luis Cazares (9/30/2014)

These are some comments with no interest on diminishing your effort.

- Design could improve, but I can't give specific ideas.--I know, it's definitely a work in progress....

Four thousand plus points....

Anyway, could I possibly prevail upon the folks around here to do a little testing for me please. I've...