Steve Jones - SSC Editor (4/17/2014)

---

rodjkidd (4/17/2014)

---

Greg Edwards-268690 (4/16/2014)

---

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like...

Greg Edwards-268690 (4/16/2014)

---

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips...

Luis,

Thanks for that, I had a complete brain freeze on how to check for A-Z and a-z. I tried A-z - which was wrong. 🙂

I did also think there was...

Given that the OP's sample data includes spaces as well as numbers...

CREATE TABLE [dbo].[Names](

[Name] [varchar](200) NULL

) ON [PRIMARY]

INSERT INTO NAMES

VALUES ('22rajuvar'),

('45 vamsgui'),

('87 praveen'),

('67kumar'),

('32 vamshi')

SELECT REVERSE(LEFT(REVERSE(name), (PATINDEX('%[^a-z]%', REVERSE(NAME)))-1)) AS CleanedName

FROM...

I worked with one dev, when I did a bit dev, pity I don't do as mush I as I'd, we still use ON ERROR GOTO don't we?

Anyway it was...

So my friend has had an internal job move while on maternity leave. In fact she went back to find that her part of the telco business has been sold...

Cool.

Always find it funny when I start a new...

The Dixie Flatline (3/31/2014)

---

Ed Wagner (3/31/2014)

---

rodjkidd (3/31/2014)

---

I do like paying it forward.

Got an email from friend who was stuck on working out how many days old a debt is at...

I do like paying it forward.

Got an email from friend who was stuck on working out how many days old a debt is at the end of the month, and...

Gail, you had 3 submitted (I think) as the order is random, I voted for the Bad Plan, Sit! one, nice title. So yes the bribe worked! Er - did...

So SQL Bits session voting has opened, I've picked my 10 which out of nearly 300 submitted was tough. Good luck to anyone who has submitted from the Thread.

Rodders...

Richard Warr (3/14/2014)

---

Seems quite widespread. I have people...

BrainDonor (3/14/2014)

---

paul.knibbs (3/14/2014)

---

I've had people who should...

andrew gothard (3/13/2014)

---

rodjkidd (3/13/2014)

---

I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%

A B A C A B

Just repeat...

I find when answering interview questions, and in particular multiple choice that the following pattern will get you close to 100%

A B A C A B

Just repeat until you have...