Thanks for the responses,

James, I also tried that and worked pretty good for the "next" but for "previous" I was having some problems but you just gave me a good idea using the asc. For example for the previous I had tried.

select top 1 * from mytable where mycolumn < 'last_col_value'

But obviously it grabs the very first record but if I change the asc/desc order to what I want I probably can get the previous record. Let me try it, thanks!