How to extract SQL statements of strings from multiple locations

How to extract SQL statements of strings from multiple locations

How to extract the SQL statement of a string from multiple locations:

Note: 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

--- Truncate the first subtitle of string

Select STUFF (A, 1, 1 ,'')

Output result: \ photo \ Winter Leaves.jpg