searching fullname

[yxez]

Hi Dearest Friends,

I have an EMP table with column FULLNAME with sample:

FULLNAME
----------
DAVID ALRIDGE
ALRIDGE DAVID
DAVID ALRIDGE WRIGHT
DAVID WRIGHT ALRIDGE
LEDAVIDE CALRIDGER

Input data for search : DAVID ALRIDGE

I want to make a query for search such that all rows in the table are valid hit except LEDAVIDE CALRIDGEAR.

Its like this:

SELECT FULLNAME FROM EMP WHERE FULLNAME LIKE 'DAVID % ALRIDGE %'
OR FULLNAME LIKE 'ALRIDGE % DAVID %';

But I can not satisfy all conditions :(

Pls help.

Thanks

[PAVB]

if your solution doesn't work yet you have to keep thinking.

[yxez]

I did Pavd ....actually its over a week now that I am puzzled by It.
Can u help please....

[PAVB]

Here is a hint...

Select  Fullname 
From    Emp 
Where   Fullname Like '%DAVID%'
    And Fullname Like '%ALRIDGE%'
;

[hrishy]

Hi

I wish PAVB was my teacher who sets my term papers with genorous dose of hints :-)

regards
Hrishy

[yxez]

Here is a hint...

Select  Fullname 
From    Emp 
Where   Fullname Like '%DAVID%'
    And Fullname Like '%ALRIDGE%'
;

But I must use the fullname index bacause it contains millions of rows dear

[PAVB]

EMP table as in EMPloyee table with millions of rows?
Don't worry, I really don't want to know.

On the other hand, as I said that was a "hint" not a solution; I'm pretty sure ontime you will be able to elaborate on it.