{"id":25561,"date":"2024-03-16T05:14:31","date_gmt":"2024-03-16T05:14:31","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/"},"modified":"2024-03-22T06:28:20","modified_gmt":"2024-03-22T06:28:20","slug":"sql-updates-lowercase-letters-to-uppercase","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/","title":{"rendered":"SQL updates lowercase letters to uppercase."},"content":{"rendered":"<p>In order to update lowercase letters to uppercase in an SQL database, you can use the built-in function UPPER().<\/p>\n<p>Here is an example demonstrating how to use the UPPER() function to convert lowercase letters in the &#8220;name&#8221; column of the &#8220;customers&#8221; table to uppercase.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">UPDATE<\/span> customers\r\n<span class=\"hljs-keyword\">SET<\/span> name <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">UPPER<\/span>(name);\r\n<\/code><\/pre>\n<p>In the example above, the UPDATE statement is used to update data in the &#8220;customers&#8221; table. The SET keyword specifies the columns to be updated, and it uses the UPPER() function to convert the lowercase letters in that column to uppercase. The UPPER() function converts all lowercase letters in the string parameter to uppercase and returns the result.<\/p>\n<p>Please note that the example above only updates the &#8220;name&#8221; column in the &#8220;customers&#8221; table. Depending on your specific situation, you may need to adjust the table name, column names, and conditions to meet your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to update lowercase letters to uppercase in an SQL database, you can use the built-in function UPPER(). Here is an example demonstrating how to use the UPPER() function to convert lowercase letters in the &#8220;name&#8221; column of the &#8220;customers&#8221; table to uppercase. UPDATE customers SET name = UPPER(name); In the example above, the [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-25561","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL updates lowercase letters to uppercase. - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL updates lowercase letters to uppercase.\" \/>\n<meta property=\"og:description\" content=\"In order to update lowercase letters to uppercase in an SQL database, you can use the built-in function UPPER(). Here is an example demonstrating how to use the UPPER() function to convert lowercase letters in the &#8220;name&#8221; column of the &#8220;customers&#8221; table to uppercase. UPDATE customers SET name = UPPER(name); In the example above, the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T05:14:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T06:28:20+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"SQL updates lowercase letters to uppercase.\",\"datePublished\":\"2024-03-16T05:14:31+00:00\",\"dateModified\":\"2024-03-22T06:28:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\"},\"wordCount\":144,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\",\"name\":\"SQL updates lowercase letters to uppercase. - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T05:14:31+00:00\",\"dateModified\":\"2024-03-22T06:28:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL updates lowercase letters to uppercase.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL updates lowercase letters to uppercase. - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/","og_locale":"en_US","og_type":"article","og_title":"SQL updates lowercase letters to uppercase.","og_description":"In order to update lowercase letters to uppercase in an SQL database, you can use the built-in function UPPER(). Here is an example demonstrating how to use the UPPER() function to convert lowercase letters in the &#8220;name&#8221; column of the &#8220;customers&#8221; table to uppercase. UPDATE customers SET name = UPPER(name); In the example above, the [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T05:14:31+00:00","article_modified_time":"2024-03-22T06:28:20+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"SQL updates lowercase letters to uppercase.","datePublished":"2024-03-16T05:14:31+00:00","dateModified":"2024-03-22T06:28:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/"},"wordCount":144,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/","url":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/","name":"SQL updates lowercase letters to uppercase. - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T05:14:31+00:00","dateModified":"2024-03-22T06:28:20+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/sql-updates-lowercase-letters-to-uppercase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL updates lowercase letters to uppercase."}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25561","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=25561"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25561\/revisions"}],"predecessor-version":[{"id":59673,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25561\/revisions\/59673"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=25561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=25561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=25561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}