Limits of GROUP BY??

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

Code:

---

handsetid|handsetname|handsetmake

---

tariff table

Code:

---

tariffid|tariffname

---

deals table

Code:

---

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

Code:

---

o2xxx, o2yyy, o2zzz, tmxxx, tmyyyy

---

Would this be at all possible?

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

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

You have saved me hours of work here!