Hi,

My Question is related to SQL Query. Let me explain it using an example.



Suppose an access table having records 001,002,003,004,005

Now what I want to do is using Select Query sort the records in such a way that it first display 004 and then the remaining records
So the list will display something like this

004
001
002
004
005


I can only use ONE sql query to sort and display the records in above mentioned format


Thank you,
Zeeshan Ahmed

__________________
Zeeshan Dar
itHighway
Get in Touch with People Texting your Website
Advanced Real Estate Listings Solution - FREE Hosting

If you're looking for Sql experts, I think you better ask your question in the Sql forum, and not in the Html forum, don' you think?

Over here, there are just Html experts..... ;)

Imar

Select count(*) from "your tab-name" where "fiel-name" <> "004"

...and later on in the script when you want to write the list to the screen, start with 004 (if this is current every time) and then you "response.write" the querry!

ok, I did misunderstand you just a bit! #-) You need to control the cursor to stop by the last record -1! Hmmmm...