Good!

That's it for this section! Before we move on, let's review what we've learned:

• + is the concatenation operator and CONCAT() is the concatenation function; they merge multiple strings into one;
• LEN() returns the length of a string, after removing the trailing spaces;
• the LOWER() and UPPER() functions change all letters in a string to lowercase or uppercase, respectively;
• LTRIM(), RTRIM(), and TRIM() return a string after removing spaces from the left, right, or both sides of a given string, respectively;
• REVERSE() returns text with all the characters in reverse order;
• REPLACE(x,y,z) will search x for y. If it finds y, it will replace it with z;
• TRANSLATE(x,y,z) will find occurences of characters from y in string x and will replace them with correspoding characters from z;
• REPLICATE(x,n) will return a string with x repeated n times;
• STUFF(s,x,y,z) inserts a new string (z) into a string s at the position x, deleting y characters starting from the x position;
• SUBSTRING(s,x,y) returns part of string s, starting from position x and returning the number of characters defined by y.

Now for a bit of practice!