Re: to copy a record

On 2003.06.04 12:48 Jim C. Nasby wrote:
> SELECT * INTO TEMP temp_table FROM blah;
> UPDATE temp_table SET field = newvalue;
> INSERT INTO blah SELECT * FROM temp_table;


Looks sweet.  Much simpler what I was doing, too


Thanks

Take care,
Jay