Question 14
You've created a simple select statement that returns the customers first name and last name. This statement needs changing so that it only includes the customers first initial and their last name in the result set. There is no column for initial. Which function could you use to get the initial?

You could do something like this:

SELECT LastName, SUBSTRING(FirstName, 1, 1) AS Initial

warning This is a sample question. You can start the practice exam by clicking the 'Start Practice Exam' link on the exam page.

Back to practice exam

Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Copyright © Accelerated Ideas 2005-2019
All rights reserved