>>>>I have a table with part numbers that show a length for the part numbers in another field.
>>>>
>>>>I need to find all of the numbers that contain "2479" and replace the length for these numbers with a value that is 4 more than the current value.
>>>>
>>>>Can anyone help me with a quick code to do this?
>>>>
>>>>Thanks in advance.
>>>>
>>>>Brad.
>>>
>>>Is this field a numeric field or char field?
>>>
>>>Jeff
>>
>>The part number is a character field and the length is numeric.
>
>Simplitic way
>
>select table1
>locate
>scan for at('2479',partnofield)<>0
> replace lenfield with lenfield+4
>endscan
>
>
>HTH
>Jeff
Thanks Jeff that did it!
I do very little programming and am working on learning more. Stuff like this is very helpful.
Brad.
He is there and He is not Silent.