February 5th, 2013, 07:10 PM
Need Help With Cases
I'm a complete noob to MySQL and I'm hung up on the following 2 parts of my assignment for class:
-Show the first (first_name) and last (last_name) names for everyone in the customer_contacts table for everyone whose first name includes a capital 'A' but not a lower case 'a'.
-For some strange reason the boss orders you to display the last names of everyone in the customer_contacts table with the last name (last_name) in the form XtheRestOfTheNameX, where the Xs represent a capitalized first letter and last letter of the last name. For example, 'Einsten' would be displayed as 'EinsteiN'.
Can someone please point me in the right direction with these?
February 5th, 2013, 08:56 PM
Originally Posted by FionaCat86
the expressions required will involve either columns (like first_name, last_name) or functions operating on columns (like SUBSTRING and UPPER)