Both my code and Ramani's will replace the TYPE929 field with "FACTR" for every record that has PTYPE='1440'. (The REPLACE command has an implicit ALL when you use a FOR clause.)
I believe Dave's would work as well, although I haven't used the SQL Update command myself.
Did you try the suggestions? Did they not work? What DID happen?
Why are you using CASE at all? Just use the REPLACE statement I mentioned above all by itself. That will scan through the table for any records that have PTYPE='1440' and replace field TYPE929 with 'FACTR' in each. No CASE or loop of any kind required.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.