sql server gourp by 条件中有text文档类型的解决办法

select 
	cast(h_contents as varchar(8000)) as h_contents
	,h_update
	,count(1) 
from huida 
where ********* 
group by 
	cast(h_contents as varchar(8000))
	,h_update order by id asc