>>>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
You can't use the Group By clause under this condition! Is this field only required for output or this field identifies records to be grouped together?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com