Search in NTEXT column in SQL

To search in a column in SQL whose DataType is NTEXT or NVARCHAR use the reserved word LIKE
See the Example Below 
use DBName
select * 
from dbo.TableName
where NTextFieldName LIKE 'Your Search Word or Sentence'