>Hi,
>
>Is there anything wrong with this statement?
>
>
>replace allt(left(dssmain.dlcinc_m95,2)) with "19"
>
>
>Please advise?
Jolene,
Yes there is something wrong with it. The REPLACE command takes a field name as the first argument not an expression. What, exactly, are you trying to do? Is it to replace the first two characters of the field with "19"? If that's it then this should work;
REPLACE dlcinc_m95 WITH "19" + SUBSTR(dlcinc_m95,3)