Pretty sure + means concatenate, otherwise that SQL statement would not work in any I can imagine.
Bob S > On Jan 14, 2020, at 10:05 , Klaus major-k via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Hi Bob, > >> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode >> <use-livecode@lists.runrev.com>: >> >> The only problem I see here is that it is possible to get a match with the >> last part of one column and the first part of the next, especially with >> numerical data, which would be a false positive. > > AHA, so SQL treats this: > ... WHERE ((col1+col2+aCol1+aCol2) ...) > > Like this in LC: > ... WHERE ((col1 & col2 & aCol1 &aCol2) ...) > ? > >> Bob S _______________________________________________ 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