Establishes a collection of records from a domain, view, collection, or list. The collection formed with the FIND statement becomes the current collection. Format FIND rse
1 – Argument
rse Is a record selection expression specifying the records to be included in the collection.
2 – Examples
The following example forms a collection of yachts longer than 30 feet and gives the collection the name BIG-ONES: DTR> FIND BIG-ONES IN YACHTS WITH LOA GT 30 [57 records found] DTR> The following example forms a collection of the 10 most expensive yachts: DTR> FIND FIRST 10 YACHTS SORTED BY DESC PRICE [10 records found] DTR>