requete sql

select * TableSalarie
where champ1 is not null 
and champ2 is not null 

procedure TForm1.Button1Click(Sender: TObject);
begin
  ADOQuery1.Open;
  with ADOQuery1.SQL do
  begin
    Clear;
    Add('SELECT  * From Matable');
    Add('WHERE (CHAMP1 is Not NULL) OR');
    Add('(CHAMP2 := param ');
    ADOQuery1.FieldByName('parame').Value := MaValeur;
    ADOQuery1.Open;
  end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  ADOQuery1.Open;
  with ADOQuery1.SQL do
  begin
    Clear;
    Add('SELECT  * From Matable');
    Add('WHERE (CHAMP1 is Not NULL) AND');
    Add('(CHAMP1 <> '');
    ADOQuery1.Open;
  end;