.dat file row swap

[Lahorem]

I have a .dat file that Iam accessing using unix / SQL:

File format is:

Row 1 Row2 Row3 Row4
x y w d
x t w d
x y w 5


I need to swap the data in row4 and row1 with each other .. the fields are defined as digits but of different lengths in the table.

what I can't figure out is how to swap the rows around in the .dat file?

Any idea Guys / Girls?? thnx in advance

 

[SQLDenis]

??
don't know if this is what you need
you are talking about fields not rows right and this is in SQL not is some file right?
If this is true then

update table
set field1 =field4,field4=field1

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLBill]

It doesn't look like you are using SQL Server for your database. So you should post this in the proper forum.

-SQLBill

Posting advice: FAQ481-4875