6363 – programming note to self – | The Scotto Grotto (org)

filename: Mid([Database_Location], InStrRev([Database_Location],””) +1)

from another Query ([Server_Names]):
dl (which is the Database location full path)
Server name
Share name

SELECT [Server_Names].[Server Name], [Server_Names].[Share Name],
Mid([dl],InStrRev([dl],””)+1) AS [FN]
FROM [Server_Names]
ORDER BY [Server_Names].[Share Name];

=====

December 28, 2007 9110 – Friday mom and Wilton left after pancake breakfast vegged all day and watched Anne of green […]
August 17, 2010 From Twitter 08-16-2010 From Twitter 08-16-2010 03:54:17: From Twitter 08-15-2010: 03:35:24: From Twitter […]
September 2, 2002 Just installed Debian on Big Brain to go along with Windows 2000.... it runs very […]
July 3, 2017 July 03, 2017 at 12:10AM Newton, 12 years ago. via Instagram http://bit.ly/2sDhm81
August 18, 2009 0817092211.jpg 0817092211.jpg 0817092211.jpg, originally uploaded by scottobear. slug lovin’ in […]