What do you mean? The playoffs are just about to start![/url]

Got it. I thought the bad characters were appearing both inbetween and outside. Sorry about that.

matt.parry (6/9/2010)

---

Lowell - thank you very much that is perfect!

Stefan - thanks for the post but I used the replace function and the characters where too inconsistent and on the...

There's a very simple way: Use the REPLACE function.

For example

SELECT REPLACE(REPLACE(SampleColumn, '*', ''), '-', '')

FROM SampleTable

[/Code]

Just nest the REPLACE for each character you want to remove and replace it with...

Your solution was fine, but the OP...

Consider the difference between

SELECT E.EmployeeID, E.LastName, E.FirstName, D.DepartmentID, D.Department,

P.Project, P.ProjectID, PD.ProjectDetailID, PD.ProjectDetail PD.Comments

FROM Employee E

INNER JOIN Department D

ON E.DepartmentID = D.DepartmentID

INER JOIN ProjectInterim PRI

ON PRI.EmployeeID = E.EmployeeID

INNER JOIN Project P

ON...

David.Poole (6/8/2010)

---

Self-documenting code is another thing that REALLY annoys me. When there are things like nDoc, JavaDoc, SQLDoc etc the idea that I have to check everything out of...

Ah, sorry. Sadly, it is only available in 2008.

In older...

Thomas-282729 (6/8/2010)

---

Stefan Krzywicki (6/8/2010)

---

While it may be "more logical", it isn't really within your power to ensure the developers code things your way. One of the main reasons for aliases...

I would suggest this article[/url] by Jeff Moden. It is one of the best solutions I've seen.

meichner (6/7/2010)[hr

Before I go about changing anything I just want to re state something so I can be sure of my design going forward. We are saying that its...

Thomas-282729 (6/7/2010)

---

You must supply the table name/alias and therefore the context to understand their meaning. "CustomerName" on a table called "Customer" is redundant as we would reference the column as...

Thanks! I've bookmarked it so I can rad it this weekend when I have the time.

Yeah, that could work if he doesn't want to use the TallyTable for some reason. Though from his examples, I think...

Is it always alpha then numeric? In the example you sent me, it was the other way around.