Limits of GROUP BY??

[nikomou]

Hello,

I have 3 tables in a database, the first being a list of handsets, the second a list of tariffs and the third a list of the deals..

handsets table

handsetid|handsetname|handsetmake

tariff table

tariffid|tariffname

deals table

dealsid|dealsinfo|tariffid|handsetid

I am planning on using Join Left to join the tables together which I shouldnt have any problems doing..

My problem here is that I want to use GROUP BY on the first 2 characters of the tariffid field..

an example of the tarrifid

o2xxx, o2yyy, o2zzz, tmxxx, tmyyyy

Would this be at all possible?

[Twey]

Certainly: ... GROUP BY SUBSTRING(tariffid, 0, 2)

[nikomou]

twey, once again.. thank you VERY VERY much!

You have saved me hours of work here!