Is it possible to use SQL string functions, e.g. LEFT, to generate sql like the following:
DECLARE @path AS NVARCHAR(450)
SET @path = '/folder1/folder2/folder3'
SELECT TOP 1 * FROM TB_SEC_FOLDER
WHERE LEFT(@path, LEN(PATH)) = PATH
AND FOLDER_TYPE = 'T'
ORDER BY DEPTH DESC
