RE: LIKE search with different orders

2004-04-10 Thread Matt Chatterley
ernative! Cheers, Matt -Original Message- From: Tarik ANSARI [mailto:[EMAIL PROTECTED] Sent: 10 April 2004 14:51 To: [EMAIL PROTECTED] Subject: LIKE search with different orders Hello again, To follow my previous message, the CONCAT method does works, but now my problem is to make a sear

LIKE search with different orders

2004-04-10 Thread Tarik ANSARI
Hello again, To follow my previous message, the CONCAT method does works, but now my problem is to make a search where the order doesn't count : then to find members whose firstname is john, lastname smith and vice-versa. I would like to use an operator or a function for this, but I cannot enumer