Hi sheena,

>>>replace all May_1998 with 2 for May_1998 = 0 and ((start_da < {1998/06/01}) and (final_da > {1998/05/01}))
>>>
>>>thanks in advance.
>
>Hi :
>
>not doing a replace when I have records that meet the criteria.

It might be a problem with an index order which is based on the May_1998 column. To identify if this is the problem add a NOOPTIMIZE clause at the end of the command and check if this works.

Another possibility is that your SET DATE setting is sert at something else as AMERICAN. Check what {1998/06/01} evaluates to by doing a WAIT WINDOW DTOC({1998/06/01}) before the replacement.

Good luck.

Walter,