Finding Specific Position in a String

[Zurich98]

hello all,

I only want the string after the second "\" in the string below:

'C:\DailyReports\April2010'

How can I accomplish this? Your help/suggestion is greatly appreciated.

Thanks

 

[drlex]

On the assumption you're using T-SQL, look up the string function CHARINDEX.
You may need to use it twice to get the second occurence if the first is variable.

soi là, soi carré

 

[markros]

Take also at this blog

http://bradsruminations.blogspot.com/2009/07/cool-cross-apply-tricks-part-2.html

of how to apply CROSS APPLY to make the code easier.

PluralSight Learning Library

 

[genomon]

A good start would be to take a look at CHARINDEX and SUBSTRING functions in BOL.

Beir bua agus beannacht!