It looks like you are looking for 'HARDDISK' at the start of the field ( AT()=1 )
The best way would be to have an index on the UPPER(stockname)
Then
Browse for upper(stockname)='HARDDISK'
OR
Browse Key 'HARDDISK' (After Index is set)
OR
SELECT * FROM TableName WHERE UPPER(stockname)='HARDDISK'
Without testing I would guess the second is fastest
Bob
>what's the fastest way to search for a word?
>
>I use:
>
>SET FILTER TO AT(UPPER('HARDDISK'),UPPER(stockname))=1
>BROWSE
>
>but I think it's too slow
>
>thanks for the help
>
>Jerry
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'