When I tried to select a table which includes a text type field using distinct. I got these error:
The text data type cannot be selected as DISTINCT because it is not comparable
The solution is convert text to VARCHAR(MAX).
Varchar(Max) is a LOB datatype and has a max size of 2GB.