INSTR from right to left?

[JohnnyRocket]

I have a column with filenames formatted like blah/blah/blah/filename.txt

I just want to display "filename.txt"

I have started with:

SELECT right(Parameters, instr(Parameters,'/'))
From Table

Obviously this only removes the first path name. Does anyone know how I can get INSTR to read from right to left (or any other method of solving this) so I can isolate the location of the last '/'

 

[BobLoblaws]

This works in VB. I don't know about SQL. Hope it helps.

SELECT right(Parameters, Len(parameters) - instrrev(Parameters,'/'))
From Table

 

[redlam]

Hi.
Try this:
select right(parameters,charindex('/',reverse(parameters))-1)
from table