Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Patindex Rss

   Items 1 to 4 of 4   
 

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.   Read more...
By Alan Burstein 2015/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 973 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 19,204 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 19,204 reads

PATINDEX Workbench

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.   Read more...
By Additional Articles 2011/05/23 | Source: SimpleTalk | Category: patindex
Rating:  Rate this |   Briefcase | 4,847 reads
   Items 1 to 4 of 4   
 
Tags
t-sql (3)    
inline table valued function (1)    
itvf (1)    
regex (1)    
set-based (1)    
string manipulation (1)    
strings (1)    
table valued function (1)