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   
 

CHARINDEX()

By Bill Lantz 2013/05/21 | Category: charindex
Rating: (not yet rated) |  Discuss |   Briefcase | 2,093 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: SQLServerCentral.com | Category: charindex
Rating: |  Discuss |   Briefcase | 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,434 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 | 1,941 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,669 reads
   Items 1 to 5 of 5   
 
Tags
string manipulation (2)    
t-sql (2)    
blogs (1)    
recursive function (1)    
split (1)    
stored procedures (1)