截取text列里面的内容

select  '延期' as type,COUNT(*)  as zongShu
from dbo.Client_Business  where  BizCateCode  =  '12B'  
and  ApplyDate > '2010-01-01'  and  ApplyDate  < '2010-06-30'
and
SUBSTRING(
convert(varchar(8000),Content) ,
PATINDEX('%<申请性质>%',convert(varchar(8000),Content))+6,
PATINDEX('%</申请性质>%',convert(varchar(8000),Content))-(PATINDEX('%<申请性质>%',convert(varchar(8000),Content))+6 )
) like '%2%'

今天要截取一个类型是text里面的字段，用到了substring(类型,)