Sir These values may Change 20.699 184.238 MV. So I need to change the text Inside () only and the rest should be as per the original
>Have you tried
>
>
>replace all;
> detail with "20.699 184.238 MV (XXXXXXXXXX)SH "
> FOR ALLTRIM(DETAIL)='20.699 184.238 MV (. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .)SH'
>
>
>
>>I need to replace
>>
>>'20.699 184.238 MV (. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .)SH'
>>
>>with
>>
>>20.699 184.238 MV (XXXXXXXXXX)SH inside a Cursor
>>
>>Using LOCATE FOR ALLTRIM(DETAIL)='20.699 184.238 MV (. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .)SH'
>>
>>I can reach the record, now I need to Replace Detail with 20.699 184.238 MV (XXXXXXXXXX)SH
>>
>>What is the easiest Way to do it.
>>
>
>
>>
Harsh