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

Content with tag charindex Rss

   Items 1 to 9 of 9   
 

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,024 reads

The Path

By Steve Jones 2016/02/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,676 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,196 reads

Find the position of all occurrences of an expression within a string

This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.  Read more...
By Steven Willis 2015/05/12 | Source: SQLServerCentral.com | Category: charindex
Rating: |  Discuss |   Briefcase | 1,939 reads

CHARINDEX()

By Bill Lantz 2013/05/21 | Category: charindex
Rating: (not yet rated) |  Discuss |   Briefcase | 2,150 reads

Find the position of all occurrences of an expression within a string

This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.  Read more...
By Steven Willis 2015/05/12 | Source: SQLServerCentral.com | Category: charindex
Rating: |  Discuss |   Briefcase | 1,939 reads

A simple math expression solver

Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.  Read more...
By Ben Kubicek 2011/11/21 | Source: SQLServerCentral.com | Category: recursive function
Rating: |  Discuss |   Briefcase | 5,516 reads

String Manipulation - CHARINDEX()

I see charindex used quite commonly in string manipulation.  What I rarely see used is the optional third parameter.  Here...  Read more...
By Seth Phelabaum 2009/12/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,359 reads

Split function with store procedure

This example return a value with split function  Read more...
By Luis Atondo 2008/09/29 | Source: SQLServerCentral.com | Category: split
Rating: |  Discuss |   Briefcase | 1,717 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (5)    
string manipulation (4)    
patindex (2)    
substring (2)    
blogs (1)    
characters (1)    
left() (1)    
len (1)    
recursive function (1)    
reverse (1)    
split (1)    
sql (1)    
stored procedures (1)