In this challenge, you will write several Transact-SQL queries by using strings and string functions. First, you will launch Microsoft SQL Server Management Studio, and then you will develop queries that return string character counts and use UPPER and LOWER functions. Next, you will develop more specific queries which replace characters in a string and use string parsing to extract data. Finally, you will explore queries that search for characters in a string by using the CHARINDEX function. Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.
Learning Objectives
In this challenge, you will write several Transact-SQL queries by using strings and string functions. First, you will launch Microsoft SQL Server Management Studio, and then you will develop queries that return string character counts and use UPPER and LOWER functions. Next, you will develop more specific queries which replace characters in a string and use string parsing to extract data. Finally, you will explore queries that search for characters in a string by using the CHARINDEX function. Note: Once you begin a challenge you will not be able to pause, save, or return to your progress. Please ensure you have set aside enough time to complete the challenge before you start.