Add or Concatenate String in SQLite

 In SQLite to concatenate string we will using SQLite: || Operator, and this below  is syntax and example.



Syntax:

string1 || string2 || string3 [ || string_n ]


Example:

Command

SELECT 'SQLite' || ' Text 1';

Result: SQLite Text 1



Reference: https://www.techonthenet.com/sqlite/functions/concatenate.php


Reactions

Post a Comment

0 Comments