"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]