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 |
|
kt
Yak Posting Veteran
88 Posts |
 Posted - 2015-09-23 : 17:55:19
|
| i have the table to store the value:\\file0\shares\_Reporting\Q\BR01\Test.txthow can i select to get only the file name which is Test.txt?Thanks |
|
|
MuralikrishnaVeera
Posting Yak Master
129 Posts |
Posted - 2015-09-25 : 05:04:18
|
| create table test(strVal varchar(max))insert into test values('\\file0\shares\_Reporting\Q\BR01\Test.txt')select REVERSE(substring(reverse(strVal),0,PATINDEX('%\%',reverse(strVal)))) from test---------------Murali KrishnaYou live only once ..If you do it right once is enough....... |
 |
|
|
|
|
|
substring query