I need to parse file name and file path from full path using SQL Query.
Eg. Fullpath - SERVERD$EXPORTFILESEXPORT001.csv
FileName Path
EXPORT001.csv \SERVERD$EXPORTFILES
See Question&Answers more detail:osI need to parse file name and file path from full path using SQL Query.
Eg. Fullpath - SERVERD$EXPORTFILESEXPORT001.csv
FileName Path
EXPORT001.csv \SERVERD$EXPORTFILES
See Question&Answers more detail:os