String concatenation does not work in SQLite

by

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.

More Related Contents:

  1. How to use GROUP BY to concatenate strings in MySQL?
  2. Select first row in each GROUP BY group?
  3. Splitting string into multiple rows in Oracle
  4. SQLite – UPSERT *not* INSERT or REPLACE
  5. Why does Oracle 9i treat an empty string as NULL?
  6. How can I list the tables in a SQLite database file that was opened with ATTACH?
  7. Update table values from another table with the same user name
  8. SQL Select between dates
  9. How to split a single column values to multiple column values?
  10. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  11. FULL OUTER JOIN with SQLite
  12. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  13. sqlite database default time value ‘now’
  14. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  15. SQLite – ORDER BY RAND()
  16. SQL string comparison, greater than and less than operators
  17. SQL Server convert string to datetime
  18. Select random row(s) in SQLite
  19. Splitting the string in sql server
  20. sqlite alter table add MULTIPLE columns in a single statement
  21. Drop all tables command
  22. SQLite auto-increment non-primary key field
  23. How do I remove extended ASCII characters from a string in T-SQL?
  24. How to create timestamp column with default value ‘now’?
  25. SQL Server *= Operator?
  26. Unfindable SQLite Syntax Error
  27. UPDATE and REPLACE part of a string
  28. Counting the number of occurrences of a substring within a string in PostgreSQL
  29. How to select the first N rows of each group?
  30. Converting String List into Int List in SQL

Leave a Comment