how to get the middle string you need something like that declare @text varchar(64) set @text = ‘123|456|798’ SELECT SUBSTRING(@text,CHARINDEX(‘|’, @text) + 1,LEN(@text) – CHARINDEX(‘|’, @text) – CHARINDEX(‘|’, REVERSE(@text)) )
One of the new features of SharePoint 2013 is the SharePoint Store. Similar to the Windows Phone Marketplace and Google Play Store, this new feature gives site owners the ability to discover and download apps for SharePoint from the store and install them on their SharePoint Sites. Furthermore, if you are a developer for your… Continue reading Configure an Environment for Apps for SharePoint 2013
It’s been noted that the “Sign in as a Different User” menu command is missing in SharePoint 2013 (e.g., see http://dirkvandenberghe.com/2012/07/18/sharepoint-2013-login-as-a-different-user.html). One suggestion for a fix can be found here: http://www.little.org/blog/2012/07/17/launch-your-web-browser-as-another-user/. This “Sign in as Different User” menu item is very useful when testing applications, but it can lead to problems especially when opening documents, say in… Continue reading Sign in as Different User and SharePoint 2013
Business Purpose This is a SharePoint plugin used with SharePoint Foundation is designed to force updates from Active Directory to SharePoint Foundation. This plugin ensures that user information within SharePoint sites is updated daily. Without this plugin, names, job titles, and email addresses may become out-of-date on each individual SharePoint site. Technical Information A SharePoint… Continue reading Synchronize User Profiles with Active Directory in SharePoint Foundation 2010 / 2013
This Blog is about .NET / SharePoint 2010 / 2013 Development solutions so watch this space for futher information, tutorials and more.