Re: [sqlite] What is the sqlite concatenation operator?

[T&B]

Hi James,

What is the sqlite concatenation operator?

Ohh, ooh, I actually know this one. Pick me, pick me... ;-)

The concatenation operator (for joining strings) is a double bar: ||

eg:

SELECT 'hi ' || 'there'

gives:

'hi there'

See:
http://www.sqlite.org/lang_expr.html
where it says, in part:

The || operator is "concatenate" - it joins together the two strings of its operands.

Hope this helps,
Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------