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 |
|
Chris_Kelley
Posting Yak Master
114 Posts |
 Posted - 2014-10-14 : 17:24:14
|
| c |
|
|
Chris_Kelley
Posting Yak Master
114 Posts |
Posted - 2014-10-14 : 17:33:15
|
| Im sure this will make most of you laugh, but i'm about to go with --select replace(SUBSTRING(filename,charindex('1\',filename),8),'1\','') from #Filesresults--(No column name)y53052y53061y53071I feel like I am just taking up space today, I hate that |
 |
|
|
|
|
|
Right function