sql split path

 declare @str varchar(100)
set @str = 'C:/data/test.csv'

declare @idx int, @len int
set @len = len(@str)
set @idx = @len
while(@idx > 0 and substring(@str, @idx, 1) <> '/') set @idx = @idx - 1

if @idx - 1 > 0
    print 'path = ' + substring(@str, 1, @idx - 1)
print 'file = ' + substring(@str, @idx+1, @len-@idx)



<script src="http://shots.snap.com//client/inject.js?site_name=0" type="text/javascript"></script>