On Oct 10, 2012, at 7:21 PM, jkp487-sql...@yahoo.com wrote:

> New to SQLite. Is there a way to get column data type information for 
> derived columns in a query or view? For example, if I have something like 
> this:
> 
> 
> select Customer.LastName || Customer.FirstName as Fullname

cast perhaps, e.g.:

select cast( Customer.LastName || Customer.FirstName as text ) as Fullname

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to