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;
UPPER() functions change all letters in a string to lowercase or uppercase, respectively;
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
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!