>>Hi,
>>
>>I'm doing a select that contains a text field and trying to do a group by. SQL telle me I can't have text fields in the group clause. Fine- I take it out of the group clause and SQL now tells me that the statement can't run because the field isn't in an aggregate function or the group by clause!
>
>Do you really need this huge field to be of a text Datatype? A VarChar field hold up to 8000 characters and can be used in Group By clause.
yes ... I can't guarantee less than 8K though it probably would be
Ken B. Matson
GCom2 Solutions