http://www.sqlservercentral.com/Content tagged T-SQL, Patindex posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.

]]>http://www.sqlservercentral.com/articles/String+Manipulation/94365/Thu, 29 Nov 2012 07:00:00 UThttp://www.sqlservercentral.com/articles/String+Manipulation/94365/The PATINDEX function of SQL Server packs powerful magic, but it is easy to get it wrong. Phil Factor returns to the Workbench format to give a tutorial of examples, samples and cookbook ideas to demonstrate the ways that this underrated function can be of practical use. It is intended to be pasted into SSMS and used as a basis for experiment.

New! Safeguard your SQL backups Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

]]>http://www.sqlservercentral.com/redirect/articles/73724/Mon, 23 May 2011 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/73724/