Limitation with "text" field in Sybase 1

[DilipKS]

Hi
Am new to Sybase. I am working on a web based ASP .NET application. AM using Sybase as database. I am facing two problems with Text field .
1) I need to populate 1 combo box from distinct values from a table. The query is like -
Select distinct(ErrorDescription) from Errrors

Its giving error "Text and Image Data Type may not be selected as DISTINCT"

Is there any alternate way ?
2) I am using a Stored Procedure to pouplate records in a table. One field is text field . There is a limitation that we cant use "text" field as a paramtere in a Stored Procedure.
Does anyone has solution ?

Thanks and Regards
Dil

 

[mjuell]

Select distinct(convert(varchar(255),ErrorDescription)) from Errrors..

If text is longer than 255 chars, then the rest is cut off.