MS SQL Server

In Built Function in T-SQL - Reverse

Reverse - Returns the reverse of a character expression.
REVERSE( character_expression )


For Eg.


Select CompanyName,


Reverse(CompanyName) As ReverseName,


Reverse(Left(CompanyName,5)) As ReverseFirst5Char,


Reverse (Right (CompanyName,5)) As ReverseLast5Char


From Customers



Result




Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL Functions
Newer Post Older Post Home

Blog Archive

  • ►  2016 (12)
    • ►  October (1)
    • ►  September (1)
    • ►  July (2)
    • ►  June (4)
    • ►  March (2)
    • ►  February (2)
  • ▼  2015 (24)
    • ►  November (1)
    • ►  October (1)
    • ►  August (3)
    • ►  July (4)
    • ►  June (5)
    • ▼  April (10)
      • In Built Function in T-SQL - Reverse
      • In Built Funtion in T-SQL - Left and Right
      • In Built Function in T-SQL - Upper and Lower
      • SQL Query To Find Last Day of Previous Month
      • Find Which Version Of SQL Server You Using
      • Find Number Of Table in Database Query
      • Find Empty Table In SQL Server
      • Find Alternate Row - TSQL Query
      • Find / Remove Duplicate From Table T-SQL Query
      • Find Record From Table That Does Not Exist In Othe...

Popular Posts

  • SSRS Expression to convert Second to Hours
    Following Expression in SSRS will convert Second to Hours Minutes Second Format HH : MM : SS   =Floor(sum(Fields!Second.Value)/ 3600)...
  • Add Default Constraint GetDate() to Existing Column
    Add constraint default getdate to existing column Alter table [dbo].[Child] Add Constraint DF_Last Default Getdate() For [LastUpdate]...
  • Find Non Integer From SQL Column
    If you want to find Non-Integer from Column in SQL Server  that does not have Data Type integer , Use following SQL Query. Select *  Fr...
  • User Define Function When LTrim and RTrim not Working
    Ltrim and RTrim not always Working to remove white space from column because of the special character at end. It may be because user try to ...
  • SQL Query to Convert Multiple CSV Column to Row
    Suppose you have following kind of table that has multiple CSV and you want to convert it to Row. Want Result like :   ...
  • Find Non Date in Column using IsDate
    Suppose We have Employee Table with Hiring Date and HiringDate is with Data Type Nvarchar. We want to find out which one is non date in Hir...
  • Find Record From Table That Does Not Exist In Other Table
    Write The SQL Query to Find Record From Table Employee That Does Not Exist in Other Two Table Employee_Ah and Employee_BA Query 1 ...
  • Calculated Age Column in SQL Server Using Function
    Function to Calculate Age Column based on Floor. Create FUNCTION [dbo] . [fnCalcAge] (    @DOB datetime , -- Provid...
  • Find Primary Key, Foreign Key, Constrain in SQL Table
    Find Column Name, Primary Key, Foreign Key, Constrain for particular Table in Database.     SELECT distinct             ...
  • Find / Remove Duplicate From Table T-SQL Query
    Find Duplicate Record Query Select        MemberID,        Name,     ...

Followers

Powered by Blogger.