Hi Mike, Am 17.09.2012 um 18:38 schrieb Mike Bonner <bonnm...@gmail.com>:
> Might look here. > http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103033 Theres an > example for locating an exact match that is simple, another > example that uses like, but not sure you'd want to mess with it. (seems to > be a convoluted way to use 'or') ah yes, the first example sounds doable, but "PATINDEX" and "COALESCE" is scarying me a bit :-D > I also found this, --select * from contacts where concat(last_name, ' ', > first_name) like '%re%'-- > Maybe you can do something this way. Thanks and 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