SQL Server REVERSE() Function

Example

Reverse a string:

SELECT REVERSE('SQL Tutorial');
Try it Yourself »

Definition and Usage

The REVERSE() function reverses a string and returns the result.

Syntax

REVERSE(string)

Parameter Values

Parameter Description
string  Required. The string to reverse

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Reverse the text in CustomerName:

SELECT REVERSE(CustomerName)
FROM Customers;
Try it Yourself »

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.