Menu ▼



Posted By :
avatarmrkraju
Total Views : 442

SQL REVERSE function

SQL string REVERSE() function was introduced in SQL Server 2008. REVERSE() function will returns the reverse order of a string value. If you given integer value or datetime to reverse() function it will first convert to string value and then returns the reverse value of it.

Example

SELECT REVERSE('HELLO WORLD')
Output
DLROW OLLEH


Example

SELECT REVERSE('56789')
Output
98765


Example

SELECT REVERSE(GETDATE())
Output
MP74:01 5102 2 ceD


Example






comments powered by Disqus


Search dotnetlearners.com