Selon Hassan Schroeder <[EMAIL PROTECTED]>: > Mathias wrote: > > > This is the right structure including "The" in the middle : > > mysql> SELECT * FROM names ORDER BY case when substring(name,1,3)='The' > > then REPLACE(name,'The ','') > > else name end; > > ? all of which produces exactly the same result as: > > SELECT * FROM names ORDER BY TRIM(LEADING "The " FROM name); > > But I guess when simplicity just won't do... :-) > > -- > Hassan Schroeder ----------------------------- [EMAIL PROTECTED] > Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com > > dream. code. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
yes, your method is simplier and i never said the opposite. We learn from each other :o) good ! Hope that helps :o) Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]