Calculated column would take care of it nicely...

...if you do it right, one follows the other.

Heh... I understand that COALESCE is more portable than ISNULL... that's one of the fortunate functions... I just wanted to make sure that someone didn't actually believe they could write...

What's in the TEXT column?

Heh... no... I always try to use the method with the best performance instead of documenting why performance can suffer... it's part of my 3 rules of a DBA.

Andrew Shaw (4/21/2008)

---

Yep, I know how to do all of that. Thought you were somehow suggesting using the view in the calculated column formula.

I need this value writing up...

ALZDBA (4/21/2008)

---

Indeed, I forgot about the currency signs. :crying:

Thank you for providing the faulty example.

They'd better remove...

Chris used the method I would have. Ryan's is also a viable solution.

Sorry guys, I lost track of this one... what ended up winning the race on the 4 million row test? RegEx or one of the functions?

Two way street here, Kaushik... how about telling us how you did that...

Then, try this on a couple of the VARCHAR(255) columns...

SELECT *

FROM T12

WHERE DATALENGTH(columnname)-LEN(columnname) <> 0

If you get any returns, it may be because data...

Try this first... check Books Online for how to read the output...

DBCC SHOWCONTIG (T12) WITH TABLERESULTS, ALL_INDEXES

Are the columns defined as CHAR() instead of VARCHAR()? Depending on system settings, that could be the problem.

This is how you could do it in a view... but a view is not needed. This also works directly in code. It works because there is only...

mail2dinesh.sharma (4/20/2008)

---

333233343MVF is such example. Until now I have seen only alphabets and numbers but not any special characters. Beside the value I receive is from an external source so...