>>>>>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.
Yeah, SpatialQueryLanguage :) I like those features.
Cetin