String concatenation does not work in SQLite

The || operator is the concatenation in SQLite. Use this code:

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

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.