Hi Jude
Seems like, to append a string using an update query, use the concatenation operator "||". For example, if you have a column that holds "Hello" and you want to end up with "Hello World", you can write:

UPDATE your_table
SET your_column = your_column || ' world'
WHERE your_condition;

If you're working with pointer fields in InterSystems IRIS (like accessing a property, for example, "PAPER_PAPMI_DR.PAPMI_No") rather than using "->", be sure to use dot notation. So your updated query might look like:

UPDATE SQLUser.PA_Person
SET PAPER_REMARK = PAPER_REMARK || 'abc'
WHERE PAPER_PAPMI_DR.PAPMI_No = '1111'
  AND PAPER_ROWID = '2222'

This method efficiently appends the string to your existing data.

Thanks Joel
Very simple & effective 👍

Thank you
I tried this and it worked