Averen

Ok I'll try that, thanks.

Oh you were asking the guy that posted the SQL not me, haha. Anyway, that sql doesn't work for me either.

That I am. :)

Hey there, I currently have a table [table] [tr][td]id[/td][td]name[/td][td]text[/td][/tr] [tr][td]1[/td][td]var1[/td][td]text[/td][/tr] [tr][td]2[/td][td]var1[/td][td]moretext[/td][/tr] [tr][td]3[/td][td]var2[/td][td]text[/td][/tr] [tr][td]4[/td][td]var2[/td][td]moretext[/td][/tr] [/table] Now I want to group this table by name, but have the group have the longest 'text' eg [table] [tr][td]name[/td][td]text[/td][/tr] [tr][td]var1[/td][td]moretext[/td][/tr] [tr][td]var2[/td][td]moretext[/td][/tr] [/table] Anyone have any ideas?