SQL query

I am writing a search engine to search for few words in a field, it am trying to make it work like below:

If the user wants to find the fields containing the words "HISTORY ASIA", it should display in the following order:

i) All fields having the words HISTORY and ASIA should be displayed first.
ii) All fields having the word HISTORY should be displayed next
iii) All fields having the word ASIA should be displayed next.

I am trying to the above query in a single statement with LIKE and OR clauses, but is not returning in the proper order.

thanx,
swamy

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful