On Mar 29, 2006, at 5:03 PM, Gary Edge wrote:
Hi All,
For some reason I was under the impression that I could write a query
statement that contained an expression that combined columns in the
result.
e.g.:
"select FieldA + ',' + FieldB, Field C from tableA"
where FieldA could be a last name and FieldB the first name and FieldC
could be the age. So a row returned in the recordset would return
idxfield(1) = "Edge, Gary" and idxfield(2) = 36.
I've looked through the SQLite.org site and experimented some but
haven't found if SQLite supports this.
You can
try
select FieldA || ',' || FieldB, Field C from tableA
|| is the SQL standard concatenation operator
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
