Re: Three cheers for 4gl's CONSTRUCT

I hate to be the one who puts a damper on all this enthusiasm for CONSTRUCT but it has to be looked at from the engine's point of view. If you allow full use of CONSTRUCT you allow poeple to query on non-indexed fields, to use wildcards before text in fields which again overrides the indexing. On a large database this can be very expensive. I personally recommend use of CONSTRUCT be restricted to situations where it is not possible to do the searching any other way. And then only by a well-trained users. Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc