SQL Basics: Search in nText columns

Anybody ever tried to search in ntext or text fields on MS SQL Server? Common experience is to fail. Solution: cast your search-term to text type, and try again. Example, using EA-Database: SELECT * FROM t_xref x WHERE x.Description LIKE...