Database Administration Fundamentals (WS18SQL1001) – Day 2

We have started having fun with built-in functions (set of instructions) for strings (character arrays).

  1. UPPER() — upper case
  2. LOWER() — lower case
  3. RTRIM() — trim spaces on the right
  4. LTRIM() — trim spaces on the left
  5. RIGHT() — part of a string starting on the right
  6. LEFT() — part of a string starting on the left
  7. SUBSTRING() — part of a string in the middle
  8. LEN() — length of a string
  9. REPLACE() — to replace part of a string

Download the notes for day 2.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.