Eric M Russell (1/4/2017)

---

As a side note, it would be great if all valid codes could be pre-loaded into a primary keyed master table, then data validation could be enforced...

Luis Cazares (1/4/2017)

---

Does this works?

IF (SELECT OBJECT_ID('tempdb..#MyTemp')) IS NOT NULL

DROP TABLE #MyTemp;

CREATE TABLE #MyTemp (QuestionableColumn CHAR(20));

INSERT INTO #MyTemp (QuestionableColumn)

VALUES ('ABC1GKUCEEF7AR169582'), --Good value

('ABC2G1WG5E37D1157775'), --Good value

('BCD3GTU2TEC9FG119962'), --Good...

Thom A (1/4/2017)

---

Brandie Tarvin (1/4/2017)

---

Thom A (1/4/2017)

---

I'm a little confused,on one part. You stated that "a hyphen is only allowed after the first character", however that the value "ABC-1245Z" is...

drew.allen (1/4/2017)

---

But you can...

The main differences between CASE and COALESCE() are that COALESCE() is faster to type and CASE gives you other data manipulation options. Otherwise, they are mostly identical in the way...

Thom A (1/4/2017)

---

I'm a little confused,on one part. You stated that "a hyphen is only allowed after the first character", however that the value "ABC-1245Z" is acceptable. The hyphen is...

Or use a CASE statement.

SELECT Col1, Col2,

CASE WHEN cte1.Col IS NULL THEN cte2.Col ELSE cte1.Col END AS MyCol

FROM ....

This assumes that you can join the CTEs to each other...

Siiiiiigggggghhhhh.

You would think when I get an alert that a log file drive is full in a non-prod system the first thing I would look at is whether or not...

Eirikur Eiriksson (12/16/2016)

---

Phil Parkin (12/16/2016)

---

Grumpy DBA (12/16/2016)

---

Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family...

Beware the Twitter list. For it is a way of defining you and boxing you into a corner!

Actually, lists can be followed as a whole (I don't remember how) so...

JustMarie (12/13/2016)

---

drew.allen (12/13/2016)

---

Does any else think that this response borders on being unethical? http://www.sqlservercentral.com/Forums/FindPost1842475.aspx It sounds like she wants to use this approach just to avoid due...

Beatrix Kiddo (12/12/2016)

---

Do you have Vick's First Defence (First Defense ;-)) nasal spray over there? I find it quite good- not sure how scientific it is, but my theory is...

Gah. Less than a week until my parents visit for two weeks and I catch a cold. The last thing I need to do is give it to them because...

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

Oh poo....

Bare