# Addig string to text field in sqlite

**URL:** https://discourse.nodered.org/t/addig-string-to-text-field-in-sqlite/1487
**Category:** General
**Created:** [10 July 2018 15:01 UTC](https://discourse.nodered.org/t/addig-string-to-text-field-in-sqlite/1487 "2018-07-10T15:01:18Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Andres](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andres/32/112_2.png) [@Andres](https://discourse.nodered.org/u/Andres)
#### Post date: [10 July 2018 15:01 UTC](https://discourse.nodered.org/t/addig-string-to-text-field-in-sqlite/1487/1 "2018-07-10T15:01:18Z")

</div>

Hi everyone, i want to add data to a text field in sqlite, something like the following:

UPDATE temp SET field = field + " - new data" WHERE field = "old data"

what im expecting is to store "old data - new data", is there a way to do that?

---

<div class="post-metadata">

### Author: ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [10 July 2018 16:25 UTC](https://discourse.nodered.org/t/addig-string-to-text-field-in-sqlite/1487/2 "2018-07-10T16:25:37Z")

</div>

The string concatenation operator is `||`.

[https://www.sqlite.org/lang\_expr.html](https://www.sqlite.org/lang_expr.html)

---

<div class="post-metadata">

### Author: ![Andres](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andres/32/112_2.png) [@Andres](https://discourse.nodered.org/u/Andres)
#### Post date: [12 July 2018 12:20 UTC](https://discourse.nodered.org/t/addig-string-to-text-field-in-sqlite/1487/3 "2018-07-12T12:20:59Z")

</div>

thank you very much!!!!