{"id":4699,"date":"2022-02-12T17:41:46","date_gmt":"2022-02-12T17:41:46","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4699"},"modified":"2022-02-12T17:42:26","modified_gmt":"2022-02-12T17:42:26","slug":"use-of-upper-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-upper-function-in-sql\/","title":{"rendered":"Use of UPPER Function in SQL"},"content":{"rendered":"\n

Use of UPPER Function in SQL:<\/h2>\n\n\n\n

(1) \u201cUPPER\u201d function is used for converting text in upper case.<\/p>\n\n\n\n

(2) Let’s take an example to convert the text of Vendor Name into Upper case as shown.<\/strong><\/p>\n\n\n\n

(3) Select the database in the SQL server and click on the \u201cNew Query\u201d button as shown.<\/p>\n\n\n\n

\"Select<\/figure><\/div>\n\n\n\n

(4) After that new query editor opens as shown.<\/p>\n\n\n\n

\"new<\/figure><\/div>\n\n\n\n

(5) After doing the above steps, write a query in the editor, as shown.<\/p>\n\n\n\n

\"Upper<\/figure><\/div>\n\n\n\n

Source Code:<\/strong><\/p>\n\n\n\n

–\/\/UPPER Function
Select [No_] AS [Vendor No.],[Name] AS [Vendor Name],
UPPER([Name])AS [UPPER(Text into Upper case)]
Fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972]\u00a0
–\/\/UPPER Function<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

(6) Then Execute or Press F5 to run the query and see the result as shown.<\/p>\n\n\n\n

\"execute<\/figure><\/div>\n\n\n\n
\n\n\n\n
Use of RIGHT Function in SQL<\/mark><\/a>
Use of DATALENGTH Function in SQL<\/mark><\/a>
Use of CHARINDEX Function in SQL<\/mark><\/a>
UPPER (Transact-SQL)<\/mark><\/a>– Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of UPPER Function in SQL: (1) \u201cUPPER\u201d function is used for converting text in upper case. (2) Let’s take an example to convert the text of Vendor Name into Upper case as shown. (3) Select the database in the SQL server and click on the \u201cNew Query\u201d button as shown. (4) After that new query editor opens as shown. (5) After doing the above steps, write a query in the editor, as shown. Source Code: –\/\/UPPER FunctionSelect AS , AS ,UPPER()AS Fromdbo.\u00a0–\/\/UPPER Function (6) Then Execute or Press F5 to run <\/p>\n","protected":false},"author":1,"featured_media":4707,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[48],"tags":[529,527,530,526,528],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Use-of-UPPER-Function-in-SQL.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4699"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=4699"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4699\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4707"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}