how to: retrieve only filename when filename and path are in field

[akalinowski]

OK, so i have a database with product information and part of it is the path to the image, they never named the image anything consistent (as in style number.jpg or product_id.jpg)
fields look like this X:\images\mens\tops\randomness.jpg X:\images\mens\pants\random.jpg
i need random.jpg and randomness.jpg only because i am moving everything to a single directory
i need to pull the file name form the database for the product image, i tried using right and charindex but it just gives me everything right of the 1st
akalinowski

 

[drlex]

In these circumstances, I'd use REVERSE and RIGHT
alongside CHARINDEX:

SELECT RIGHT([filelocation],(CHARINDEX('\',REVERSE([filelocation])+'\'))-1)

soi là, soi carré

 

[Olaf Doschke]

I'd solce this on the client side, fetch the whole name and then use
-PHP: basename()
-ASP.NET, C# and VB.net: System.IO.Path.GetFileName()
-Python: os.path.basename(filePath)
-FoxPro: JustFName()
...

Bye, Olaf.