SQL Server String Truncation

Known: field a = 'f: \ photo \ winter leaves.jpg'
Requirement: Segment each character segment. [field a cannot be of the text type; otherwise, an error is returned.]
Solution:
++ ++

--- Truncate the first \ left string of string
Select left (A, charindex ('/', a)-1)
Output result: F:
++ ++

--- Intercept the \ intermediate string
Select left (stuff (A, 1, charindex ('/', a), ''), charindex ('/', stuff (A, 1, charindex ('/', a), '')-1)
Output result: Photo
++ ++

--- Truncate the string following the last \
Select reverse (left (reverse (A), charindex ('/', reverse (A)-1 ))
Output result: winter leaves.jpg
++ ++

 

--- capture the first subtitle of string a
select stuff (, 1, 1, '')
output result :: \ photo \ winter leaves.jpg
++ ++