Question:
How can I put a variable in a SQL string? For example:
input:=edit1.text;
query1.sql.add('select * from address where name like <%variable input%>');
Answer:
Since SQL.Add takes a string, all you need to do is simple string concatenation:
var
qryVar : String;
begin
...
SQL.Add('select * from address ' +
' where name like ''' + qryVar + '''');