SQL question

[Klaus on-rev]

Hi Mike,

Am 17.09.2012 um 18:38 schrieb Mike Bonner <bonnmike at 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
klaus at major.on-rev.com