Remove everything to the right of the LAST nth character

[bmacbmac]

Hello, I have the following in a varchar field:

c:\temp\123.tif
c:\temp\124.tif
c:\temp\images\124.tif
c:\temp\images\today\125.tif

I would like to remove everything to the right of the last '\' so I end up with
c:\temp
c:\temp
c:\temp\images
c:\temp\images\today

I have been trying charindex, but it's not working out for me:

select left(myfield, CHARINDEX( '\', reverse(myfield)))from mytable

Can someone help me out with this?

Thanks!

 

[fredericofonseca]

select left(myfield, len(myfield) - CHARINDEX( '\', reverse(myfield))) from mytable

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[bmacbmac]

Worked perfectly! Thanks!