>Just add your AND and ORDER by clauses on after the '%wik%'. But I don't know why there's a '7' at >the end of your original line. I don't think it does anything. Perhaps a typo when you made the post ?
>SELECT * FROM sitelist >WHERE sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes LIKE >'%wik%' >AND category='Bundled Software' >AND owner='Gary' >ORDER BY sitename Hello Simon, that's what I tried first (yes, the '7' was a typo, sorry) and it didn't work. I know there is a limit to field concatenation this way but I don't know what it is so will have to play as it is not giving me any results at the moment. Oh well, thanks for the idea...I don't really need any sleep tonight..:):) -- View this message in context: http://old.nabble.com/Search-multiple-columns-AND-extra-comparator-tp28356196p28356587.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
