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.
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.