RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
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:
x