{"id":4783,"date":"2022-02-12T18:58:56","date_gmt":"2022-02-12T18:58:56","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4783"},"modified":"2022-02-12T19:02:39","modified_gmt":"2022-02-12T19:02:39","slug":"use-of-substring-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-substring-function-in-sql\/","title":{"rendered":"Use of SUBSTRING Function in SQL"},"content":{"rendered":"\n

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

(1) \u201cSUBSTRING\u201d function is used to extract characters from the string with defined length and position.<\/p>\n\n\n\n

(2) Let’s take an example to extract the first two characters from Vendor Name 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

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

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

–\/\/Use Of SUBSTRING Function
Select [No_] AS [Vendor No.],[Name] AS [Vendor Name],
SUBSTRING([Name],1,2)AS [SUBSTRING (extract first 2 characters)]
Fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972]
–\/\/Use Of SUBSTRING 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 AND operator in SQL<\/mark><\/a>
SQL ORDER BY Statement<\/mark><\/a>
SQL WHERE Statement<\/mark><\/a>
SQL SELECT DISTINCT Statement<\/mark><\/a>
SUBSTRING (Transact-SQL)<\/mark><\/a>– Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of SUBSTRING Function in SQL: (1) \u201cSUBSTRING\u201d function is used to extract characters from the string with defined length and position. (2) Let’s take an example to extract the first two characters from Vendor Name 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: –\/\/Use Of SUBSTRING FunctionSelect AS , AS ,SUBSTRING(,1,2)AS Fromdbo.–\/\/Use Of SUBSTRING <\/p>\n","protected":false},"author":1,"featured_media":4788,"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":[549,548,547,546,550],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Use-of-SUBSTRING-Function-in-SQL.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4783"}],"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=4783"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4788"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}