- 2 years ago 176
SQL Question

String concatenation does not work in SQLite

I am trying to execute a SQlite replace function, but use another field in the function.

select locationname + '<p>' from location;

In this snip, the result is a list of 0s. I would have expected a string with the text from locationname and the

Answer Source

Try using || in place of +

select  locationname || '<p>' from location;

From SQLite documentation:

The || operator is "concatenate" - it joins together the two strings of its operands.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download