How to select DISTINCT values on TEXT columns

-- To avoid error: "The text data type cannot be selected as DISTINCT because it is not comparable."

-- list all descriptions (and duplicates) (TEXT datatype)
SELECT original_desc FROM Report..A0004_01;

-- list all descriptions (without duplicates) (convert TEXT datatype)
SELECT DISTINCT CONVERT(VARCHAR(MAX), original_desc) FROM Report..A0004_01;