distinct character from a string alphabatically
I have single column table, that contains names of emp. The data is like below.
Name
-----------
John S Smith
S John Smith
Smith John S
......
......
like that. Basically the names mentioned above is a single person information but some times First_name came first, some times last_name came first...etc...
Is there any way to get the output like below.
JShimnot
The output is the distinct combination of characters alphabatically.