>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...
Erik Moore
Clientelligence