shift records in the table

<i><b>Originally posted by : rudi (andyrudolf@hotmail.com)</b></i><br />Hi, <br />I have a small table with 2 columns: <br />OrderNo.....Description <br />...0.........Message#0 <br />...1.........Message#1 <br />...2.........Message#2 <br />...4.........Message#4 <br />...6.........Message#6 <br /><br />Is there a way to write a SP/select statement or do it in ASP, so that if there is a gap in the sequence of OrderNo of more then 1(OrderNo is not an identity field) then the table will look like:<br /><br />OrderNo.....Description <br />...0.........Message#0 <br />...1.........Message#1 <br />...2.........Message#2 <br />...3.........Message#4 <br />...4.........Message#6 <br /><br />( and OrderNo #4 will be changed to OrderNo #3)<br />Thanks,<br />Rudi <br /><br />