How to display PREV and NEXT values from a String

[ElEye]

I have a table whose Primary Key is a Text column. I wish to display the PREVIOUS and NEXT values. If the Primary Key column were a Number this would be easy. But since it's a String I would have to poll the table to discern the preceding and following values. The question is how do I get the PREVIOUS and NEXT values as variables so I can response.write them?

The SELECT to display one record looks something like this:
strSQL = "SELECT * FROM [mytable] WHERE [PrimKey] = " & mykey

TIA!


Dave
[

http://flashspot.com

]