Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Patindex Rss

   Items 1 to 12 of 12   
 

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 2016/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,346 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,927 reads

Find a String in a String

Learn how you can find data in a string and extract it, no matter where it's located.  Read more...
By Steve Jones 2016/03/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,079 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,927 reads

Extarcting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern  Read more...
Rating: |  Discuss |   Briefcase | 1,227 reads

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 2016/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,346 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,927 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,927 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,927 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,753 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,753 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,998 reads
   Items 1 to 12 of 12   
 
Tags
string manipulation (3)    
charindex (2)    
set-based (2)    
string function (2)    
strings (2)    
substring (2)    
characters (1)    
exclude pattern (1)    
inline table valued function (itvf) (1)    
itvf (1)    
pattern exclude (1)    
pattern replace (1)    
regex (1)    
replace pattern (1)    
sql (1)    
table valued function (tvf) (1)    
tally table (1)