Hi, I have a set of records selected, for example, with:
"select * from NewsData where (upper(Zip)>='HX1' and upper(Zip)<'HX2') order by Zip,Address,No" There is an INTEGER PRIMARY KEY field in the database called ID Given that I know I have a record with an ID of 12345, how would it be possible to "jump" to that record, and still maintain my original select parameters and order? I guess that this is down to a select within a select, but I'm not sure how to go about it. Well, I'll qualify that - anything that I've tried hasn't worked yet! Thanks a lot, Brian Pugh, Halifax, England
