Anil Kolla (9/28/2015)
SELECT RIGHT([FileName],CHARINDEX('\',REVERSE([FileName]),-1 )) AS NameOfFile
'Zactly.... no expensive double reverse required. One is bad enough. 😀 No length calculation required, either.
--Jeff Moden
Change is inevitable... Change for the better is not.