Last post Aug 06, 2013 12:37 AM by aaa_78600
Aug 05, 2013 10:21 PM|aoshi_kh|LINK
i have a fields that keep data like "HelloAll Morning", anyone know when select this field, when detect a space between.. I want the display to become "Morning HelloAll"; exchange place.
eg: HelloAll Morning --> Morning HelloAll
John Smith --> Smith John
Aug 06, 2013 12:37 AM|aaa_78600|LINK
i don't know Oracl.
i know sql server
CHARINDEX(' ',REVERSE(' '+COLUMN_NAME)))+' '
+LEFT(COLUMN_NAME, CHARINDEX(' ',COLUMN_NAME))
If you will try above query in sql server you will get your output.
try to convert same query in oracle.i hope you will get your result.