Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mmats
Starting Member
47 Posts |
 Posted - 2004-04-26 : 11:26:09
|
| is there a function or a way that will find the last '\' in a path. for example 'd:\programs\file.exe' , is there a method i could use in a query to find the '\' right before file.exe? |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-04-26 : 11:33:03
|
| select charindex('\', reverse('d:\programs\file.exe'))Duane. |
 |
|
|
Mmats
Starting Member
47 Posts |
Posted - 2004-04-26 : 11:48:27
|
| nice...thanks alot |
|
|
|
|
|
|
Function that will find last '\' in a path?