REVERSE(string)

Returns a character string with the order of the characters reversed. Note that leading spaces in any string types are considered as significant, unlike trailing spaces which are not considered as significant.

The following example illustrates the use of the REVERSE function.

SELECT REVERSE(dept_name) from COURSE where dept_name = 'Music'

Results set:

               cisuM

               cisuM

               cisuM

               cisuM

               cisuM

5 rows were affected.

 

Thursday, 18 April 2019 Posted in String Functions