Hi Fabio,

What do you mean by "this command is dying"?

I was planning to try to use it after you mentioned it "is the best VFP function".

Mike

>
>
>I love the LOOKUP function, but forgot to mention it! Not many use it.
>LOOKUP is probably the fastest way to seek a record and return a value.
>Too bad first parameter is not an expression!!!!
>
>
>
>This is the best VFP function.
>The best of the best is this:
>the REPLACE can do the operation without the index,
>remove the index parameter and if the a index exist VFP optimize it with a true SEEK
>(not like a partial seek done into the FOR clause),
>otherwise it do a scan with 2X faster respext to a FOR .
>
>Sin that this command is dying.
>
>I have put a wish for a
>LOOKUP(expr,...)
>and for
>LOOKUPRECNO(expr,nRecNo,'Alias') ( use a table like a rows array )
>
>Fabio