inputfilename= xxxx/yyyyyyy/zzzzzzzzz/sample.txt

I have to just print out sample.txt. Another inputfilename can have value such as

xxxxxxxxxxx/yyyyyyyyyy/zzzzzzzzzzzzzzzz/sample2.in

As you can see, the letters preceding file can be varied, so we cannot use

SELECT substr(inputfilename,24)

FROM table;

because the letters preceding the file is varied.

What I am thinking is going from backwards and stop at the first'/'. so it will get sample.txt and sample2.txt.

Any help would be really appriciated.

The harib- there are many different ways to do this:

find the total length of string using LEN() function... then

find the position of the first occurance of '/' from backward using STRSTR() -- string search function.

then use SUBSTR() function from last position to the position where that '/' is.

By the way, wha is the system? Oracle or SQL server?