sql - Insert (append) memo lines to database using a parameter -

how can append cxmemo1 text database field (which memo type) contains data ? if use :

datamodule2.t2.params.parambyname('a3').value := cxmemo1.text;

the prior text gets overwritten. how can append ?

this part of update query.

in update query may use :

update table t set    t.my_memo_field = coalesce(my_memo_field,'') || :a3  t.id = :pkey

update: added coalesce in case of old value null.

Call