Eliminate duplicates with text field

[Kubilus1]

I have a parameterized stored procedure that I need to eliminate duplicates from. I tried using SELECT DISTINCT, but I get an error saying that the text field cannot be selected as distinct. One of the fields is a text field.
Looked in BOL and it doesn't offer much help

Is there some way to get around this?
Is there another keyword I could use?

(running SQL server7, Sp3 on winNT 4 sp6)

Thanks,
Matt

 

[aalmeida]

it all depends on you data and table schema up to 8000 characteres you could use SELECT DISTINCT cast(ColName, as varchar) n = 1 to 8000.
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Kubilus1]

Thank you, thats exactly what I needed.