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

Content with tag charindex Rss

   Items 1 to 5 of 5   


By Bill Lantz 2013/05/21 | Category: charindex
Rating: (not yet rated) |  Discuss |   Briefcase | 2,122 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 2013/04/12 | Source: | Category: charindex
Rating: |  Discuss |   Briefcase | 965 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: | Category: recursive function
Rating: |  Discuss |   Briefcase | 5,481 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,081 reads

Split function with store procedure

This example return a value with split function 
By Luis Atondo 2008/09/29 | Source: | Category: split
Rating: |  Discuss |   Briefcase | 1,692 reads
   Items 1 to 5 of 5   
string manipulation (2)    
t-sql (2)    
blogs (1)    
recursive function (1)    
split (1)    
stored procedures (1)