sqlstr:='select * from yourtable where ';if checkbox1.checked then sqlstr:=sqlstr+'xm="yourname"';if checkbox2.checked then sqlstr:=sqlstr+'and bj="sdfas"';