Hi All,

I want to group items in a report by not a field but
a part of field. For example useid is 12 digit number
and 5th to 6th position indicate the are of this user.
I want put sql code like Group by substr(userid,5,2).
I tried that but VFP 6 does not seem to like it.
Column not found error message comes on. Off cause
this could be FoxFire's(I am beta testing Fox Fire)
limitation that I don't know about.
May be my approach is not permissable. If so is there
any trick I can use to achieve this end.
Thanks for your help always.

Aiko Ichimura