Raymond Irving <[EMAIL PROTECTED]> writes:
> How do I concatinate two or more strings or fields in SQLite?
>
> Select CustomerID,CompanyName,ContactName + '/' + ContactTitle As 'Contact',
> Address From Customers
The SQL concatenation token is "||":
SELECT CustomerID,
CompanyName,
ContactName || '/' || ContactTitle AS Contact,
Address
FROM Customers;
Derrell
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
