Hi, is this a bug or not? I'm using MySQL 3.23.49!
When I want to use this: SELECT CASE WHEN hmContactGroup.Id = 1 THEN CONCAT(hmContact.FullName, ' ', hmContact.CountryId) ELSE COALESCE(hmContact.DjName, hmContact.FullName) END AS ContactName FROM hmContact, hmContact_ContactGroup, hmContactGroup WHERE (hmContactGroup.Id = 1) AND (hmContactGroup.ShowLinkGroup = 'Y') AND (hmContact_ContactGroup.ContactGroupId = hmContactGroup.Id) AND (hmContact.Id = hmContact_ContactGroup.ContactId) AND (hmContact.Website IS NOT NULL) ORDER BY UPPER(ContactName) ASC it will return with ERROR 1054: Unknown column 'ContactName' in 'order clause' Without UPPER in the ORDER BY it works. In ORACLE 8i it works ... BEST REGARDS, Robert GRAF Vienna, AUSTRIA --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php