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,
Hello,
How do I concatinate two or more strings or fields in SQLite?
For Example:
Select CustomerID,CompanyName,ContactName + '/' + ContactTitle As 'Contact', Address
From Customers
The Contact column returns 0.
__
Raymond Irving
2 matches
Mail list logo