SQL Server String Functions
SQL Server string functions are scalar functions that perform an operation on a string input value and return a string or numeric value.
REVERSE Function
The REVERSE function gives you a mirror image of a given string. The following example returns the mirror image of employee last names:
SELECT REVERSE(LastName) AS MirrorImage, LastName AS FullLastName FROM DimEmployee
Results:
MirrorImage FullLastName
trebliG Gilbert
nworB Brown
ollerubmaT Tamburello
sretlaW Walters
sretlaW Walters.
Tags: SQL Server String Functions SQL SQL Server Functions. Character String Data Types and Functions with Sample SQL Statements. Quick reference, Data Type Tables, Function Tables.
SQL Server string functions are scalar functions that perform an operation on a string input value and return a string or numeric value.
REVERSE Function
The REVERSE function gives you a mirror image of a given string. The following example returns the mirror image of employee last names:
REVERSE Function in Ms Sql Server |
SELECT REVERSE(LastName) AS MirrorImage, LastName AS FullLastName FROM DimEmployee
Results:
MirrorImage FullLastName
trebliG Gilbert
nworB Brown
ollerubmaT Tamburello
sretlaW Walters
sretlaW Walters.