{"id":4741,"date":"2022-02-12T18:22:13","date_gmt":"2022-02-12T18:22:13","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4741"},"modified":"2022-02-12T18:43:14","modified_gmt":"2022-02-12T18:43:14","slug":"use-of-replace-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-replace-function-in-sql\/","title":{"rendered":"Use of REPLACE Function in SQL"},"content":{"rendered":"\n

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

(1) \u201cREPLACE\u201d function is used to replace characters within the string.<\/p>\n\n\n\n

(2) Let’s take an example to replace \u2018A\u2019 with \u2018T\u2019 in 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

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

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

–\/\/Use Of REPLACE Function
Select [No_] AS [Vendor No.],[Name] AS [Vendor Name],
Replace([Name],’A’,’T’)AS [Replace(‘A’ with ‘T’)]
Fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972]
Where [No_] IN(‘V00040′,’45858585′,’IC1020’)
–\/\/Use Of REPLACE 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 LOWER Function in SQL<\/mark><\/a>
Use of UPPER Function in SQL<\/mark><\/a>
Use of RIGHT Function in SQL<\/mark><\/a>
Use of LEFT Function in SQL<\/mark><\/a>
REPLACE (Transact-SQL)<\/mark><\/a>– Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of REPLACE Function in SQL: (1) \u201cREPLACE\u201d function is used to replace characters within the string. (2) Let’s take an example to replace \u2018A\u2019 with \u2018T\u2019 in 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 REPLACE FunctionSelect AS , AS ,Replace(,’A’,’T’)AS Fromdbo.Where IN(‘V00040′,’45858585′,’IC1020’)–\/\/Use Of REPLACE Function (6) Then Execute or Press <\/p>\n","protected":false},"author":1,"featured_media":4751,"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":[536,537,540,538,539],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Use-of-REPLACE-Function-in-SQL.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4741"}],"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=4741"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4751"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}