{"id":4518,"date":"2022-02-12T11:45:38","date_gmt":"2022-02-12T11:45:38","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4518"},"modified":"2022-02-12T11:54:32","modified_gmt":"2022-02-12T11:54:32","slug":"use-of-charindex-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-charindex-function-in-sql\/","title":{"rendered":"Use of CHARINDEX Function in SQL"},"content":{"rendered":"\n

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

(1) \u201cCHARINDEX\u201d function is used to get the position of Character from a string.<\/p>\n\n\n\n

(2) Let’s take an example to get the position of \u2018e\u2019 from the Vendor Address field in the Vendor table as shown. Note<\/strong>: (i) This function performs a case-insensitive search and (ii) Gives first find position of the defined character (example: if we have to find the position of \u201cE\u201d in the string \u201cAmerica Export\u201d, then it gives the position value of 3, not 9.)<\/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

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

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

–\/\/CHARINDEX get position of character form Vendor Address field
Select [No_] as [Vendor No.],[Name] as [Vendor Name],
CHARINDEX(‘E’,Name)as [Charcater Position Value from Vendor Name]
fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] TB1
–\/\/CHARINDEX get position of character form Vendor Address field<\/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 CHAR function in SQL<\/mark><\/a>
How to Create Connection between Excel and SQL database<\/mark><\/a>
Use of IN operator in SQL<\/mark><\/a>
How to Install AL code extension in VS Editor<\/mark><\/a>
Getting Started with AL<\/mark><\/a>\u2013 Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of CHARINDEX Function in SQL: (1) \u201cCHARINDEX\u201d function is used to get the position of Character from a string. (2) Let’s take an example to get the position of \u2018e\u2019 from the Vendor Address field in the Vendor table as shown. Note: (i) This function performs a case-insensitive search and (ii) Gives first find position of the defined character (example: if we have to find the position of \u201cE\u201d in the string \u201cAmerica Export\u201d, then it gives the position value of 3, not 9.) (3) Select the database in the SQL server and click on the \u201cNew Query\u201d button <\/p>\n","protected":false},"author":1,"featured_media":4523,"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":[494,492,493,491,495],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Use-of-CHARINDEX-Function-in-SQL.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4518"}],"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=4518"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4518\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4523"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}