Search record in database

One of the easiest way to search record is using FindNearest property of Table component.

procedure TForm1.Button1Click(Sender: TObject);
begin
  Table1.FindNearest([Edit1.Text]);
end;