[firebird-support] How to Extract Filename from file path inside a stored procedure?

['stwizard' stwiz...@att.net [firebird-support]]

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?

 

Thanks,

Mike