Hi Peter, Am 19.09.2012 um 18:21 schrieb Peter Haworth <p...@lcsql.com>:
> On Wed, Sep 19, 2012 at 3:07 AM, Klaus on-rev <kl...@major.on-rev.com>wrote: > ... >>> Klaus, have you implemented a solution to this yet? I don't recall you >>> mentioning which flavor of SQL you're using and that makes a difference. >> ah, sorry, I will use a local SQLite database. > > OK, good to know. I don't remember all the solutions you've been given, > but here's a couple of notes. Apologies if you already know this. > > If you concatenate columns together, the operator to do that in sqlite is > || not +. > > I think there was one solution that used PATINDEX - sqlite doesn't have > that function. OK, thanks for the info! > I implemented exactly the same functionality in a name/address search db > once and ended up biting the bullet and using a WHERE clauses that tested > every column in the table for the string I was looking for. A pain to code > because I probably had 20 or 30 columns to search but sometimes the > simplest solution is the best :-) I am sure I have some old "SQL statement generator" script somewhere on my HD which will do the work for me :-) Best Klaus -- Klaus Major http://www.major-k.de kl...@major.on-rev.com _______________________________________________ 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
