I think I'm ready for a new thread. I'm seeing way too many responses to questions that not really related to the question asked. The new thread...

sgmunson (6/3/2015)

---

I'm not 100% sure I know exactly what you are looking for, but if you're looking to compute the time difference between two fields that are stored as character...

You need to sort the data by the actual date, not the date converted to varchar.

In the report,you can display the converted date.

Lowell (6/2/2015)

---

Eirikur Eiriksson (6/2/2015)

---

Lowell (6/2/2015)

---

take a look at this thread from a while ago: it's got some excellent examples on stripping out non-numeric characters in the fastest way possible.

do you...

Eirikur Eiriksson (6/2/2015)

---

Maybe mint jelly or for...

I might need a pork chop soon. I won't care if it's coated in whipped cream, BBQ sauce, or anything else!

ScottPletcher (6/2/2015)

---

Alvin Ramard (6/2/2015)

---

ScottPletcher (6/2/2015)

---

A scalar function will handle that just fine. Particularly if you do it only once, when the data is inserted. You can add a...

Regex sounds like a great idea, but I'm not aware of any way to use it without creating a CLR function.

ScottPletcher (6/2/2015)

---

A scalar function will handle that just fine. Particularly if you do it only once, when the data is inserted. You can add a format code /...

I know of any simple way to do what you're asking without using REPLACE.

FYI, using REPLACE with the format you gave looks pretty simple:

REPLACE(REPLACE(REPLACE(REPLACE(PhoneNumber, '(', ''), ')',...

Google worked fine...

In this person, weak is...

Jack Corbett (6/2/2015)

---

Alvin Ramard (6/2/2015)

---

What about the pork chops? Are they...

If you want to learn SQL, you should learn how to do Google searches first.

Try http://www.lmgtfy.com/?q=SQL+stored+procedure

Brandie Tarvin (6/2/2015)

---

Ed Wagner (6/2/2015)

---

rodjkidd (6/2/2015)

---

Ed Wagner (6/2/2015)

---

rodjkidd (6/2/2015)

---

Grant Fritchey (6/2/2015)

---

Brandie Tarvin (6/2/2015)

---

So this[/url] was in the Database Weekly and I found myself snerking about it.

I have to say that...