Search Query

[mehrdadc48]

Hi, I have a Address field.I want to make a query that returns all records that their addresses contain all words of a address in any order. Suppose 'John street , No 2' is the address, I want to return all addresses that contains 'John' , 'street', 'No' and '2' in any order. How can I make this query? Original string : My name is Mehrdad

Best wishes

[Mycroft Holmes]

Use and with like

SELECT *
FROM Somehwere
WHERE address1 LIKE '%John%'
AND address1 LIKE '%Street%'
AND address1 LIKE '%No%'

However this is not going to help where you have St instead of Street ,Rd instead of Road and many many more issues that arise from cleaning address data.

Never underestimate the power of human stupidity RAH

[Blue_Boy]

You can use SOUNDEX[^]

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com