I'm with Claude on this one, your best bet it probably to generate another column such as sortTitle that you can then sort on.
On Mon, Mar 16, 2009 at 11:39 AM, Claude Schneegans < [email protected]> wrote: > > >>but you can use string > manipulation functions in the ORDER BY clause to sort your data. > > That would prevent the query from using an index, and it may have some > impact on performance. > > An alternative would be to apply these functions once for all on the > titles, > store the result in an extra column and ORDER BY this column. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
