I have a variable which is a VARCHAR and will contain a list of folders (1 or more). It may looks like that :
@Folder = '/folder1/folder2/' or @Folder = 'folder1/folder2/' or @Folder = '/Folder1/Folder2'
And if the first and the last characater of my string are '/', i want to remove them and my variable should be always
@Folder = 'Folder1/Folder2'
Thanks for your help