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

Articles with tag charindex Rss

Search for any content tagged charindex

   Items 1 to 4 of 4   

Pattern Matching : More Fun When I Was a Kid

Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.  Read more...
By Additional Articles 2016/10/05 | Source: | Category: charindex
Rating: (not yet rated)  Rate this |   Briefcase | 2,979 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,122 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,518 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,455 reads
   Items 1 to 4 of 4