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

Content with tags Blogs, String Manipulation Rss

   Items 1 to 3 of 3   

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


No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”   Read more...
By Steve Jones 2009/10/26 | Source: | Category: blogs
Rating:  Rate this |   Briefcase | 1,861 reads

Beware the REPLACE function when doing heavy string parsing

I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work with, so I had no choice.   Read more...
By Sam Bendayan 2009/08/27 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,881 reads
   Items 1 to 3 of 3   
charindex (1)    
t-sql (1)