Thanks. This is exactly what I wanted to hear. Mik
At 04:43 AM 7/13/2007, you wrote: >Mik Muller wrote: >> >> I'm told that shorter fields will sort faster. > >They will if the content is shorter. Whether the datatype is declared as >VARCHAR(x) or VARCHAR(y) should not matter, so you might as well just >pick the longest one for all of them. > >Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

