>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.