Hi Pete, Am 15.07.2013 um 21:43 schrieb Peter Haworth <p...@lcsql.com>:
> On Mon, Jul 15, 2013 at 10:54 AM, Klaus major-k <kl...@major-k.de> wrote: > >> Same value in all columns! > > > Hi Klaus, > OK, should probably be OK then. Great, thanks! > There is one corner case but it's pretty > unlikely. > > Let's say there is a row with your three columns containing: > > code > sign > xyz > > ...and the value you are looking for is "design". Your concatenated string > will be "codesignxyz" so the row will be selected even though "design" > doesn't occur in any of the three columns. > > Pretty unlikely I know but if you want to avoid that possibility, you could > include some sort of delimiter in your concatenated string, eg: > > col1 || ' ' || col2 || ' ' || col3 thanks, doesn't apply to my needs in the moment but will surely store this for later reference! > Pete > lcSQL Software <http://www.lcsql.com> 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
