{"id":4719,"date":"2022-02-12T17:58:58","date_gmt":"2022-02-12T17:58:58","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4719"},"modified":"2022-02-12T17:59:14","modified_gmt":"2022-02-12T17:59:14","slug":"use-of-lower-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-lower-function-in-sql\/","title":{"rendered":"Use of LOWER Function in SQL"},"content":{"rendered":"\n

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

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

(2) Let’s take an example to convert the text of Vendor Name into the Lower 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

\"Lower<\/figure><\/div>\n\n\n\n
–\/\/LOWER Function
Select [No_] AS [Vendor No.],[Name] AS [Vendor Name],
LOWER([Name])AS [Lower(Text into Lower case)]
Fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972]\u00a0
–\/\/LOWER 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 UPPER Function in SQL<\/mark><\/a>
SQL SELECT DISTINCT Statement<\/mark><\/a>
How to Take BACKUP from SQL Database<\/mark><\/a>
LOWER (Transact-SQL)<\/mark><\/a>– Microsoft Docs
How to convert SQL Query into JSON Format in SQL Server<\/mark><\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of LOWER Function in SQL: (1) \u201cLOWER\u201d function is used for converting text in lower case. (2) Let’s take an example to convert the text of Vendor Name into the Lower 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. –\/\/LOWER FunctionSelect AS , AS ,LOWER()AS Fromdbo.\u00a0–\/\/LOWER Function (6) Then Execute or Press F5 to run the <\/p>\n","protected":false},"author":1,"featured_media":4723,"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":[533,532,534,531,535],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Use-of-LOWER-Function-in-SQL.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4719"}],"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=4719"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4719\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4723"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}