Back when I was working with MSSQL I need to alphabetize movie titles in the proper library format where 'A' 'An" and 'The" are ignored.
For MSSQL I was told to use: select * from Titles order by case when Title like 'The %' then substring (Title, 5, 255) when Title like 'A %' then substring (Title, 3, 255) when Title like 'An %' then substring (Title, 4, 255) else Title end That worked like a charm, yet MySQL doesn't seem to accept that. Any solutions or advice? -- Ian Evans Digital Hit Entertainment - News and Information http://www.digitalhit.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
