TDataset.Locate

Data.DB.TDataSet.Locate

function Locate(const KeyFields: string;  const KeyValues: Variant;  Options: TLocateOptions): Boolean; virtual;

TLocateOptions 

  loCaseInsensitive  //不區分大小寫

  loPartialKey          //模糊比對

Ex:

  Locate('Field1;Field2', VarArrayOf(['Value1', 'Value2']), [loCaseInsensitive, loPartialKey]);