The FIND family of procedures is the general purpose data retrieval procedure in AL. It is much more flexible than GET, and therefore more widely used. GET has the advantage of being faster as it operates only on unfiltered direct access through the primary key, looking for a single uniquely keyed entry. There are two forms of FIND procedures in AL, one a remnant from a previous database structure and the other designed specifically to work efficiently with SQL Server. Both are supported, and we will find both in standard code.
The older version of the FIND procedure has the following syntax:
[BooleanValue :=] RecordName.FIND ( [Which] ).
The newer SQL Server-specific members of the FIND procedure family have slightly different syntax, as we will see shortly.
Just like the GET procedure, assigning the FIND procedure result to a Boolean value is optional. However, in almost all of the cases, FIND is embedded in a condition that controls subsequent processing appropriately...