Select one answer The exam has timed out. Click here to start a new session for this exam © Accelerated Ideas - 2008                                                                            Accelerated Ideas - Software Solutions for Today's world
       Question and Exam Time       Proceed to the next question Next Question We appreciate any feedback on our practice exams, or if you would like to recommend some additional questions please contact us Got a comment? Submit as answer to this question                    

End the exam now and calculate your current score You can rate this exam once you have finished it Rate Exam                                                                                     Help us to improve our online exams, donate via PayPal. Its simple and takes only a few minutes to help us improve our site for everyone Accelerated Ideas was founded to provide you with the best free software, training and resources Help us Exam : 70229 Time Taken : 0 mins   Select one answer: RTRIM. RTRIM is the best choice here, it will automatically remove white spaces from the end of a string expression. You could use LEN and SUBSTRING together but that would require more code and is inefficient.        		         Choose another exam Sample Questions Go to Extras Cert Planner Go to Home    End Exam   Our Team Microsoft Practice Exams Submit Answer Options Credits Home Links You have written a stored procedure to calculate the address form a number of different fields in your SQL Server 2000 database. These fields are variable in length and you would like to make sure that the string doesn't have any additional spaces at the end when it is finally shown.

Which T-SQL function should you use?   









            
Free online Microsoft practice exams for MCAD and MCSD certifications. Exams include 70-306, 70-315, 70-320, 70-229, 70-536, 70-552, 70-526, 70-528, 70-529. Developing Windows and Web application using Microsoft Visual Studio.NET. SQL Server 2000 design and implementation. All exam questions are free for online users. New practice exams coming soon for MCTS, MCPD certifications using Visual Studio 2005. Our site does not contain braindumps nor braindump style material which disrespects and lowers the value of Microsoft certifications. We are fully committed to ensuring the integrity of Microsoft's exams and their importance in the business world.