Ah - I had forgotten the default US collation was accent sensitive. Anyway, it's interesting....

Ha! I missed an opportunity there.

I've just noticed that "IsAllDigits" includes fractions:

-- True

SELECT IsAllDigits

FROM dbo.IsAllDigits('1¼');

-- True

SELECT IsAllDigits

FROM dbo.IsAllDigits('¾5¼');

Collation-related of course. There is more between 0 and 9 than just the integers. In the...

Well it might do, or it...

Successful summit - I hugged Gail 🙂

I'm going to video it and upload to YouTube. You're welcome.

rodjkidd (10/15/2013)

---

Paul Whites session was awesome, and a lovely, if very tired, guy to meet and chat to afterwards!

It was a pleasure to meet you in person. And another tick...

rodjkidd (10/11/2013)

---

I'm going the summit - Yay - will be my first. So looking forward to meeting a lot of you in person. Attending Paul's pre-con, really looking forward to...

I'll be there. Precon on the Monday, regular session last thing Friday.

I'll be there. A bit scared, probably, but I'll be there.

Bhuvnesh (10/1/2013)

---

Paul,

Thanks for this detailed informatrion . i read...

Thanks. See you there - make sure you introduce yourself to me at some stage 🙂

Max-146500 (9/9/2013)

---

I was interested to verify the behaviour based on the PK ordering, and was relieved to see that the pk order is still used to establish the first matching...

dwain.c - Article body

---

This is interesting. We updated the Value column of our #Test1 table twice for each row. Or did we? [...(later)...] In reality we find that somehow the...

Good to know, thanks. Just for a bit of fun (and because other people might...