"Brian Pugh" <[EMAIL PROTECTED]> writes: > 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'm not quite sure what you're after. If you want the record that has ID=12345 if that record fits the WHERE criteria, you could do this: SELECT * FROM NewsData WHERE ( upper(Zip) >= 'HX1' AND upper(Zip) < 'HX2' ) ORDER by COALESCE(id = 12345, id), Zip, Address, No --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]