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.