RE: Fw: Swapping around values in a database

2003-03-15 Thread Don Read
On 15-Mar-2003 Mr Orange wrote: > Hello all : ) > > Can anyone offer any advice on how to achieve the following with SQL? > > Say I have a table. > > CREATE TABLE page ( > pgposition int(6) not null, > pgelement char(20) not null default '', > pgsize int(4) not null default '0')); >

Fw: Swapping around values in a database

2003-03-15 Thread Mr Orange
Hello all : ) Can anyone offer any advice on how to achieve the following with SQL? Say I have a table. CREATE TABLE page ( pgposition int(6) not null, pgelement char(20) not null default '', pgsize int(4) not null default '0')); and it has this data in. 1,"TEXT",20 2,"TEXT",