I am sure this question has been asked before, but there appears to be an issue with applying the || character in a view or select statement in order to concat two columns in the output.
Table Example Column1 Column2 this that then its SELECT Column1 || ' ' || Column2 as Column FROM TableExample In my specific example I am trying to concat a first name and last name into a fullname. I would simply create my own view with the console app,but i appear to have encrypted this. Thanks, Tim Tessier _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
