T-SQL - Stripping Path From FileName

[quick_dry]

cool tip - I made a slight change:

RIGHT('\'+fldFileName, CHARINDEX('\', REVERSE('\'+fldFileName))-1)

This way it will always work whether the '\' is in the filename or not (the original errors if it isn't)