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)