Jeff Moden (1/15/2009)

---

dmc (1/15/2009)

---

Haha... I agree that truely portable code is almost impossible to achieve. 🙂 But working in an environment with multiple systems we try to make...

Garadin (1/15/2009)

---

dmc (1/15/2009)

---

True... it is slightly (very slightly) faster. And in billions of rows it could make a difference. But is it wroth compliance of standards and advantages...

Chris Morris (1/15/2009)

---

Grant Fritchey (1/15/2009)

---

Oh yeah, two bows in the house, one a flat native american style long bow and the other a d-shaped english longbow with a Victorian riser...

I've got a few maritial arts weapons here at home, no swords. My pistols, however, are not stored at home at the moment as my wife didn't want them...

Jeff Moden (1/14/2009)

---

No... and today pretty much stunk...

Only because I kept reading and responding to your posts while still trying to write my first post. Sorry, don't know how to do both at the same time...

Different subject, have you had a chance to test my code yourself? After my last test, I feel much better.

Okay, I'm ready for my logical look at why it isn't a bug in the REPLACE function. First, let us think in terms of your million row test tables,...

I would call the truncation without warning a possible bug, but I think we have seen that behaviour else where in SQL Server as well. The fact that REPLACE...

Without testing...

Okay, but why? I look at it this way, if I'm willing to put down my reasoning, I think it only right to ask you to support your side...

Give me time to eat dinner, check a failed process at work, and then I'll be more than happy to explain from a logical view point why I don't think...

Greg Edwards (1/14/2009)

---

I'm thinking Gail is going who needs a 44 Magnum, when you have H&H's around.

Maybe you better think about upgrading Jeff. I'd hate for you to bring a...

To better help you, please read the first article linked in my signature block. It shows you how to create better posts to help you get better and tested...

The Canadian Postal Code has the following format: A0A 0A0. If there are no spaces in your data, then you would look for the format: A0A0A0. Perhaps ->...