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