学习了数据库中text类型的查找

set  @ReSearch= '%'+(@ReSearch)+'%';
 SELECT ID,Title,CreateDate
    from  ArticleModel
    where Description IS NOT NULL AND PATINDEX(@ReSearch,Description)>0