{"id":608,"date":"2018-02-08T11:05:04","date_gmt":"2018-02-08T16:05:04","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=608"},"modified":"2021-09-16T14:57:58","modified_gmt":"2021-09-16T18:57:58","slug":"database-administration-fundamentals-ws18sql1001-day-2","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=608","title":{"rendered":"Database Administration Fundamentals (WS18SQL1001) \u2013 Day 2"},"content":{"rendered":"

We have started having fun with built-in functions<\/a> (set of instructions) for strings (character arrays).<\/p>\n

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

    Download the\u00a0notes<\/a>\u00a0for day 2.<\/p>\n","protected":false},"excerpt":{"rendered":"

    We have started having fun with built-in functions (set of instructions) for strings (character arrays). UPPER() — upper case LOWER() — lower case RTRIM() — trim spaces on the right LTRIM() — trim spaces on the left RIGHT() — part of a string starting on the right LEFT() — part of a string starting on […]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[21,3,1,17,2],"tags":[],"class_list":["post-608","post","type-post","status-publish","format-standard","hentry","category-ws18sql1001","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=608"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/608\/revisions"}],"predecessor-version":[{"id":610,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/608\/revisions\/610"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}