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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Right function

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 #Files

results--

(No column name)
y53052
y53061
y53071

I feel like I am just taking up space today, I hate that
Go to Top of Page
   

- Advertisement -