Re: Comparing strings

[Peter Brawley]

If firstname and lastname must be processed separately as you indicate, the first thing to do is change the table structure to put them into two columns, after which you can write ...

... WHERE LOCATE(firstname,lastname)) OR LOCATE(lastname,firstname) ...

If you don't do that, you will have to write a parsing function and call it eight times per row to extract firstnames & lastnames, or write one function which does all required comparisons.

PB