>Hi everybody,
>
>I have the following replace statement:

>replace Street with m.lcNewStreetName, ;
>               ccode with m.lcNewCode, ;
>		town with m.lcNewTown, ModiType with 'C', ;			
>		(.cWorkField) with .cReplVal ;
>		for upper(ccode+town+Street+str(StNum,4)+StNumExt+Unit)= ;
>m.lcCond in BldMstr

>
>Set exact is set to off, because I want to replace old street names with the new street names regardless of StNum or StNumExt. However, if StNumExt is NULL, this replace command doesn't work.
>
>We have situs index in the table, which is exactly

>upper(ccode+town+Street+str(StNum,4)+StNumExt+Unit)

>
>Could you please advise, what should I do, to make the replace command work for NULL in Unit or StNumExt as well?
>
>Thanks a lot in advance.


for upper(ccode+town+Street+str(StNum,4)+nvl(StNumExt,space(fsize('StNumExt','BldMstr')))+...
Cetin