SQL Functions   «Prev 

String Containing Query - Exercise

Objective: 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 Submit 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 Submit button.

SELECT au_Fname + '' + au_Lname 
FROM Authors

SELECT SUBSTRING(au_Lname, 1, 3) 
FROM Authors

Please enter your SQL into the following TextBox: