select distinct (fri),tagnum from subtag where tagnum like :#p adoquery1.pararms.parambyname('#p').value := '100%';
with adoquery1 do begin close; sql.clear; sql.add('select distinct (fri),tagnum from subtag where tagnum like :#p'); params.parambyname('#p').value := '100%'; open; end;
adoquery1.pararms.parambyname('#p').value := '100%';
begin
close;
sql.clear;
sql.add('select distinct (fri),tagnum from subtag where tagnum like :#p');
params.parambyname('#p').value := '100%';
open;
end;