String Str := 'select * from studen where xm like %'+Edit1.Text+'% ';
query.sql.sqlStr= Str;
query.open;
memo1.clear;
FOR I := 0 to query.count -1 do
memo1.line.asdd(query.fieldbyname('xm').asstring);
SQLStr := 'select * from studen where xm like ''%剑%''';
if SQLStr.count >0 then
FOR I := 0 to SQLStr.count -1 do
memo1.line.asdd(AQLStr.fieldbyname('xm').asstring);