More SQL Madness!

OK, so here’s the new issue:
I’ve got a resultset with a screwy FilePath column (normally, the FilePath column has a full system-path (mac-style) stored in it). The screwy results need to have their path replaced with the correct data, without losing the actual filename that’s stored in the FilePath column.
Here’s what I’m looking at:

PMS_1106:Photos:001P1106PM.JPG

What I need to do is strip out everything but the filename (001P1106PM.JPG) and replace it with the new full system-path data.The filenames are unique, but not consistent in naming (length, letters, underscores, etc). I suppose I could work some regex magic (any a-z or A-Z 0-9 and _, – character(s), followed by a ‘.’ and [JPG|EPS|ext?]).
Hrm. might just have to experiment with this one.