>I have two sql statement: >select * from postcode where ascen(addr_array,address) >This take several seconds each time. > >The other sql statement: >select * from postcode where atc(address,m.addr)#0 >also take several seconds. > >I want it take up to one second only, any suggestions? Try setting indexes to your specifications first, then do your SQL. Right now have SQL doing 'functions' during a search which will eat up time. IE. set you index to ascending order before the SQL in the first example. HTH, Tom