I am trying to execute a SQlite replace function, but use another field in the function.
select locationname + '<p>' from location;
|| in place of
select locationname || '<p>' from location;
From SQLite documentation:
The || operator is "concatenate" - it joins together the two strings of its operands.