I'm having trouble parsing a string per say using sql. I have a column full of file paths. The file paths are similar to:
C:\Users\Guest\Pictures\example.jp
I want to be ablt to grab just the file name of the image. I've been working on several variations of a query using the substr function and the instr function. I've come up with the query below. FILEPATH is the name of the column. So far it gives me the file name, but has the '\' in front of it. Can anyone help me get rid of this. Thanks in advance.
Select substr(FILEPATH, (instr(FILEPATH,'\',-1,1)))
from Table_Name
where ID = '101'