Hi Mike, Am 17.09.2012 um 18:38 schrieb Mike Bonner <[email protected]>:
> 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 [email protected] _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
