lol. My list-of-names-that-will-screw-up-DBAs just got a little longer. ~Brad
-------- Original Message -------- Subject: Re: Order By question From: John M Bliss <bliss.j...@gmail.com> Date: Wed, June 30, 2010 3:16 pm To: cf-talk <cf-talk@houseoffusion.com> Yeah *that's* why I didn't suggest your more terse ELSE last_name Yeah. That's the ticket. ;-) On Wed, Jun 30, 2010 at 3:13 PM, <b...@bradwood.com> wrote: > > Let's hope no one has a last name starting with any of the following > characters: > > space ! " # $ % & ' ( ) * + , - . / > > All of those fall alphabetically before 0. > > :) > > ~Brad > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:334992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm