Yeah. I guess the INNER/OUTER stuff blinded me to the better function.

>>SELECT orders.id,;
>> IIF(ISNULL(clients.name),"Sir/Madam"+SPACE(n),clients.name) AS cname ;
>> FROM orders ;
>> LEFT OUTER JOIN clients ;
>> ON orders.id = clients.order_id ;
>> INTO CURSOR temp
>
>In addition, the NVL function would be better suited to this job...