Hi List, Which SQL function can help me get the file name from a string like this "C:\program files\my apps\2005\reports_New.doc".?Do We have any split function in Oracle? We are at Oracle 9.2.0.5. Thanks, Raja. -- //www.freelists.org/webpage/oracle-l