Hello group
I have a large table indexed by a varchar column
I would like to select records that are around the hit value, say "Marriot" by index order
How can I retrieve the prior and next in order?
Is there a goto "Marriot" and then a goto +1 and goto -1 SQL facility?