Hi William,

thank you very much for your help but i found the way, your idea to make index i did it but it was not work will.

but i made PRG file to make a connection with another database system and after that create a remote view and the result was WOW unbeleivable just write which value you need it to search then Ooops less than 1 second for a remote view table contains 157000 records

and these are the statements if you need it:

lcconnstr="driver=;server=;uid=;pwd=;DSN=" && you will find it from ODBC
lnrc=SQLSTRINGCONNECT(lcconnstr)

CREATE CONNECTION name of the connection DATASOURCE lcconnstr

CREATE SQL VIEW name REMOTE CONNECTION name of the connection as SELECT TableConnection.field;...;....;....

and thank you again