{"id":4763,"date":"2022-02-12T18:40:48","date_gmt":"2022-02-12T18:40:48","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=4763"},"modified":"2022-02-12T18:40:50","modified_gmt":"2022-02-12T18:40:50","slug":"use-of-reverse-function-in-sql","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/use-of-reverse-function-in-sql\/","title":{"rendered":"Use of REVERSE Function in SQL"},"content":{"rendered":"\n

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

(1) \u201cREVERSE\u201d function is used for reversing the string.<\/p>\n\n\n\n

(2) Let’s take an example of reversing the 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

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

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

–\/\/Use Of REVERSE Function
Select [No_] AS [Vendor No.],[Name] AS [Vendor Name],
REVERSE([Name])AS [REVERSE(the String)]
Fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972]
Where [No_] IN(‘V00040′,’45858585′,’IC1020’)
–\/\/Use Of REVERSE 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 GROUP BY Statement in SQL<\/mark><\/a>
Use of UNION and UNION ALL Operator in SQL<\/mark><\/a>
Use of ALIASES operator in SQL<\/mark><\/a>
Use of BETWEEN Operator in SQL<\/mark><\/a>
REVERSE (Transact-SQL)<\/mark><\/a>– Microsoft Docs<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Use of REVERSE Function in SQL: (1) \u201cREVERSE\u201d function is used for reversing the string. (2) Let’s take an example of reversing the 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 REVERSE FunctionSelect AS , AS ,REVERSE()AS Fromdbo.Where IN(‘V00040′,’45858585′,’IC1020’)–\/\/Use Of REVERSE Function (6) Then Execute or Press F5 to run the query and <\/p>\n","protected":false},"author":1,"featured_media":4767,"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":[542,545,541,544,543],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/02\/Pink-Flower-Illustration-Engagement-Card-1.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4763"}],"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=4763"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/4763\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/4767"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=4763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=4763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=4763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}