I am trying to concatenate two fields into one new field in GRASS, but I am unable to get the syntax to work. Ideally, I would like "FIELD1" and "FIELD2" concatenated together in "FIELD3". All fields are VARCHARs. I have tried:
v.db.update layername col=FIELD2 value=FIELD1+FIELD2
using many combinations of +, ||, &, and wrapping in single and double quotes all to no avail. Can someone provide some guidance on the required syntax?