> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/product-suite/admin/databox-expressions/text-expressions/rowmerge.md).

# RowMerge

This Expression constructs a string from a multi-record Databox such as can be achieved by selecting the multi-record-set option on a [SQL Query](/product-suite/admin/entities/databoxes/sql-query.md) or HTTP databox. 

The syntax of the call is:

1. format - a string containing a string with square bracketed column names to indicate the positions at which the column values should be substituted into the string
2. separator - a string containing the characters to use between each formatted string when joining the result together

<table><thead><tr><th>Expression</th><th>Databox Value</th><th width="88">Result</th><th>Comments</th></tr></thead><tbody><tr><td><code>RowMerge("[name] ([userId]), ",")</code></td><td>&#x3C;KFXmlValue rows="1">&#x3C;KFRow id="0">&#x3C;userId>1&#x3C;/id>&#x3C;name>George Smiley&#x3C;/name>&#x3C;/KFRow>&#x3C;KFRow id="1">&#x3C;userId>2&#x3C;/id>&#x3C;name>Ann Sercomb Smiley&#x3C;/name>&#x3C;/KFRow>&#x3C;/KFXmlValue></td><td>George Smiley (1), Ann Sercomb Smiley (2)</td><td>This expression compliments FieldMerge that achieves this goal only for the first record of a databox result (if multiple records exist).</td></tr></tbody></table>

{% hint style="info" %}
RowMerge is useful when you require a comma separated list of results from a SQL or HTTP databox.
{% endhint %}