Extra file name from a field in SQL

Topic

New Reply

Hi,

I have fields with image file locations stored within the SQL database.

I need to be able to retrieve just the file name and extension from the field, ie every after the last ”.

How can I do this in SQL?

The table is tblproperty and field is PICFILE

Reply | Quote

Replies

The following should do it:

FilenameExt: Mid(PICFILE, InStrRev(PICFILE, “”, , vbBinaryCompare) + 1)

Reply | Quote

Thank you.

Reply | Quote