String concatenation does not work in SQLite
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.
The ||
operator is the concatenation in SQLite. Use this code:
select locationname || '<p>' from location;
For comparison,
SQLite || Oracle CONCAT(string1, string2) or ||MySQL CONCAT(string1, string2, string3...) or || if PIPES_AS_CONCAT enabledPostgres CONCAT(string1, string2, string3...) or ||Microsoft SQL Server 2012+ CONCAT(string1, string2, string3...) or + Microsoft Access +