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

Subject	How to Extract Filename from file path inside a stored procedure?
Author	stwizard
Post date	2015-09-17T14:19:24Z

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