Hello all. Quick question. I have some fields in a table that are TEXT fields. I am having problems doing DISTINCT calls because of the TEXT datatype. What are my best options. I could do a convert in the query I guess like this.<BR>Convert(text_column_name,varchar(8000)) OR should I just change the datatype to Varchar(8000) is that a good idea to do with SQL Server 2000?