Tuesday, January 26, 2010

Comparison on Text column

In T-SQL, "Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types."

Using "Like" on the text column instead.