What is the SQL syntax to find last directory name from a file path.
For example I want to fetch the name of the last Directory i.e. C
Input:
/Directory_A/Directory_B/Directory_C/Folder1/Folder2
Output:
C
See Question&Answers more detail:os