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 CAST(‘%GUID={761F0C9E-92E4-42d1-8F0A-D3740A2BFF60}%’ AS TEXT)