Free Practice Exam -
70-464 SQL Server 2012
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?
SUBSTRING
STUFF
REPLACE
RTRIM
That was the correct answer, well done!
Sorry, that was the wrong answer
You could do something like this:
SELECT LastName, SUBSTRING(FirstName, 1, 1) AS Initial
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
Home
Microsoft Exams
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
Home
Copyright © Accelerated Ideas 2005-2024
All rights reserved