On 2 Dec 2011, at 9:03am, Kit wrote: > SELECT id, name FROM emp WHERE name LIKE '%emp%' > UNION ALL > SELECT id, descr FROM emp WHERE descr LIKE '%emp%';
I note very interesting names for the columns in this one. The question I was asking was whether the second column was called 'name' for all rows returned by this query. I also note an alternative to the above which might prove useful to the OP: SELECT id, name, descr FROM emp WHERE (name || descr) LIKE '%emp%' Or, if you want to be anal about it SELECT id, name, descr FROM emp WHERE (name || 'xoxoxox' || descr) LIKE '%emp%' Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users