{"id":4626,"date":"2022-02-12T16:28:51","date_gmt":"2022-02-12T16:28:51","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4626"},"modified":"2022-02-12T16:30:33","modified_gmt":"2022-02-12T16:30:33","slug":"use-of-len-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-len-function-in-sql\/","title":{"rendered":"Use of LEN Function in SQL"},"content":{"rendered":"\n

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

(1) \u201cLEN\u201d function is used to calculate the length of the string.<\/p>\n\n\n\n

(2) Let’s take an example to calculate the length of \u201cThe Universe\u201d 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

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

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

–\/\/LEN is used for calculating length of string
Select LEN(‘ The Universe ‘) AS [LEN (Length of Name)]
–\/\/LEN is used for calculating length of string
\u00a0
–\/\/DATALENGTH is used for calculating length of string
Select DATALENGTH(‘ The Universe ‘) AS [DATALENGTH (Length of Name)]
–\/\/DATALENGTH is used for calculating length of string<\/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 STORED PROCEDURES in SQL<\/mark><\/a>
Use of DATALENGTH Function in SQL<\/mark><\/a>
Use of CONCAT Function in SQL<\/mark><\/a>
Use of UNION and UNION ALL Operator in SQL<\/mark><\/a>
LEN (Transact-SQL)<\/mark><\/a>– Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of LEN Function in SQL: (1) \u201cLEN\u201d function is used to calculate the length of the string. (2) Let’s take an example to calculate the length of \u201cThe Universe\u201d 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: –\/\/LEN is used for calculating length of stringSelect LEN(‘ The Universe ‘) AS –\/\/LEN is used for calculating length of string\u00a0–\/\/DATALENGTH is used <\/p>\n","protected":false},"author":1,"featured_media":4630,"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":[515,512,514,511,513],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Use-of-LEN-Function-in-SQL.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4626"}],"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=4626"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4626\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4630"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}