Looping thru a Sql table changing data

[stanlyn]

Hi,

What is the best way to copy field1 into field2 both from a single sql table and into the same record. Only records matching a where clause would be processed? I do have a unique identity key...

In vfp I would

select MyTable
set filter to field1 = 'MyValue'
go top
replace field2 with field1 all

or

replace field2 with field1 for field1 = 'MyValue'

Thanks, Stanley

 

[r937]

UPDATE MyTable
   SET field2 = field1
 WHERE field1 = 'MyValue'

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[stanlyn]

Not bad at all...

Thanks, Stanley

 

[r937]

yeah, sql is pretty decent

look ma, no loop

;-)

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon