Subject How to Extract Filename from file path inside a stored procedure?
Author stwizard

Greetings All,


Firebird v1.5.3 and v2.5.4


I need a way to extract just the file name for a given file path either by code in a stored procedure or by calling a UDF in the stored procedure.


Example, I need to extract “SNKSAid.dat” from “K\Frontline\Documents\Aids\SNKSAid.dat”


Any ideas?