Introduction
Concatenation
Simple text functions
How to modify Strings
Summary
26. Summary

Instruction

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!

Exercise

Click Next exercise to begin.