How to Concatenate Two String Values in SQL
July 12, 2008
(The following example was tested in SQLite, but it should work for most versions of SQL.)
The syntax for combining two string values is the following.
SELECT Column1 || Column2
FROM TheTable
Entry Filed under: CodeSnippet, SQL. .
1 Comment Add your own
Leave a Comment
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to the comments via RSS Feed
1. Recent Links Tagged With "concatenate" - JabberTags | October 11, 2008 at 3:34 pm
[...] public links >> concatenate How to Concatenate Two String Values in SQLite Saved by poooooodle on Fri 10-10-2008 Using COALESCE function to concatenate column data in sql [...]