SQL query help

From: Hello_World <nix1_at_cuse12.se.cuhk.edu.hk>
Date: 28 Oct 2001 04:48:02 GMT
Message-ID: <9rg2m2$cdh$1@eng-ser1.erg.cuhk.edu.hk>

I want to select a recorde from the database and the output is sorted by the similarity.
e.g.
select name from emp where name like '%abc%';

If there is an excat match record abc, it will be placed in the first position on the list.
If there is a recode of abb, acc, abcd, abcaaa, cdabc, etc. in the databse, they will also be placed in the output, sorted by their similariy to abc.

What should I do?

For string match matching, I heard that there is a method called A-Grep. Is there a such thing in the string function in Oracle? Thanks in advance. Received on Sat Oct 27 2001 - 23:48:02 CDT