Hi firends, with a table consisting of 3 (or more) db fields: name tags comment
If I want to find a value in ALL of the three (or more) db fields, I now use: ... ## Pseudocode, quotes etc missing, I know! put fld "searchfield" into tUserInput select * from myTable where name LIKE %tUserInput% OR tags LIKE %tUserInput% OR comments LIKE %tUserInput% ... You get the picture :-) Now my question: Is there a shorter SQL command for my purpose, that I did not find yet? Thanks in advance! Best Klaus -- Klaus Major http://www.major-k.de kl...@major-k.de _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
