>>>>I have to ASC() the gen in order to MAX() itr as MAX() only works on numerical fields in MB.
>>>>
>>>>Terry
>>>
>>>I prefer to say 'no way' :) Probably it doesn't support having clause (as if I can think what to add if that did:)
>>>Cetin
>>
>>Correct - no Having clause
>
>and they call it SQL - SoundlikeQueryLanguage < g >
More like S**t Query Language!
On the other hand, and incongruously so, it incorpoates very powerful and possibly incredibly intricate map querying clauses, such as "where T1.obj intersects/partially within/entirely within T2.obj" et al.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.