String Containing Query - Exercise
Run queries that contain string and substring functions to see how they work.
For this exercise, you are simply going to run the queries from the lesson to see how they work. They have been placed below again for your convenience.
Copy the statements and click the
button below to go to the Web site where you can run your queries. You can paste them into the text box and submit them.
When you are done running both of the queries, click the
SELECT au_Fname + '' + au_Lname FROM Authors
SELECT SUBSTRING(au_Lname, 1, 3) FROM Authors
Please enter your SQL into the following TextBox: