I have a database Table Named P\_Columns. This Table Contains the columns

```
ID
Column_Name
Column_Type
Column_Visible
Column_Order

```

This Data table gets populated and updated by an Application which displays a dbgrid.
This application has a button. that when clicked it takes the selected row. and moves it up one row (This is where I need help). 

Now my initial SQL Statement (SELECT \* FROM P\_Columns Order by Column\_Order asc) sets the correct order. initially. 

I need to find out if there is an update Sql statement that will allow me to swap the Column\_Order of the selected record. with that of the record just before it.

Hope this makes sense.