>>>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
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com