Re: [sqlite] Field/String Concatination

2004-04-28 Thread Derrell . Lipman 
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]

[sqlite] Field/String Concatination

2004-04-28 Thread Raymond Irving 
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