You'll need to create a computed column, called say isMatch, based perhaps on their ID. You can set isMatch to a bit based on if the id matches. 1 for yes or 0 for no. Then order by can be Order by isMatch ASC, last_name ASC
On Wed, Jun 30, 2010 at 3:02 PM, Les Mizzell <[email protected]> wrote: > > Not 100% sure how to do this... > > Need to return a list of folks ordered by last_name (no problem), EXCEPT > for 2 of them. They need to be LAST regardless of their last names > (problem)... > > Perhaps something with their 2 ID numbers? > > Ideas? > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5241 (20100630) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
