The second one is rushmoreable.

>Hi Jim, so let's say that one of my fields in a cursor is order_number and is C(10) and nullable.
>
>So if I create an index
>
>

>select import_data
>index on nvl(order_number, space(10)) tag order_num
>index on customer_code tag cust_code
>

>
>Then which of the following would be correct?
>
>

>select import_data
>locate for import_data.customer_code = bulk_orders.customer_code ;
>     and import_data.order_number = nvl(bulk_orders.order_number, space(10))
>
>select import_data
>locate for import_data.customer_code = bulk_orders.customer_code ;
>     and nvl(import_data.order_number, space(10)) ;
>          = nvl(bulk_orders.order_number, space(10))
>

>
>Jason
>
>>>Is the NVL() function in fox 8 sp1 a rushmore optimizable command?
>>>
>>>Jason
>>
>>It is if your index key for a tag is on NVL(Whatever,Somethingelse)