6363 - programming note to self -
Dec. 17th, 2003 02:31 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
scottobearfilename: 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];
=====
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];
=====
Re: well..
Date: 2003-12-18 05:33 pm (UTC)