
February 5th, 2013, 07:10 PM
|
|
Registered User
|
|
Join Date: Feb 2013
Posts: 1
Time spent in forums: 25 m 7 sec
Reputation Power: 0
|
|
|
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?
Thanks! 
|