String concatenation in Table Query Module

[data-usr]

I am trying to concatenate two strings in a query inside the “Table Query” module. But it looks like ‘Concat’ function and the ‘+’ operator do not work. What's the correct way to concatenate?

[andyvidan]

The Table Query Module uses SQLite syntax, so you can concat two strings using the || operator.