>select import_data >index on nvl(order_number, space(10)) tag order_num >index on customer_code tag cust_code >>
>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)) >>