SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag String Manipulation Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (19)     SQLInsider Scripts (5)     Concatenate (1)     Recursion (1)    
Delimited Strings (6)     Table of Numbers (5)     cross apply (1)     Search (1)    
T-SQL Aids (6)     tally (5)     CTE (1)     split string (1)    
Advanced Querying (5)     XML (4)     delimiters (1)     SQLCLR (1)    
Arrays (5)     SQL Server 7, 2000 (3)     ETL (1)     SSIS (1)    
counter (5)     User Defined Function (UDF) (3)     function (1)     TEXT/NTEXT (1)    
Development (5)     2-Dimensional Arrays (2)     ISNULL (1)     truncation (1)    
nums (5)     Blogs (2)     Parsing column data (1)     User-Defined Functions (1)    
parse (5)     Administration (1)     Print (1)     XQUERY (1)    
SQL Server 2005 (5)     Coalesce (1)    
   Items 1 to 20 of 35    Next 20 >>
 

Using a function to parse/return the Nth field of a delimited column

A useful SQL function to parse a single string with delimited values for the "N"th occurrence  Read more...
By John Burnette 2009/11/06 | Source: SQLServerCentral.com | Category: ETL
Rating: (not yet rated) |  Discuss |  Briefcase | 332 reads

Characters

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: SQLServerCentral.com | Category: Blogs
Rating:  Rate this |  Briefcase | 837 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.  Read more...
By Carl P. Anderson 2009/10/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 13,303 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: SQLServerCentral.com | Category: Blogs
Rating: (not yet rated)  Rate this |  Briefcase | 1,689 reads

Splitting the string with unique delimiter.

The statement is splited into columns according the delimter and it has been captured in the table datatype.  Read more...
By Prashanth Jayaram 2009/06/29 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |  Briefcase | 874 reads

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...
By Divya Agrawal 2009/06/25 | Source: SQLServerCentral.com | Category: XML
Rating: |  Discuss |  Briefcase | 8,990 reads

SQL Server UDF to pad a string

Unlike other relational database management systems that shall remain nameless, SQL Server's underlying coding language, T/SQL, does not have a built-in function for padding string values. I recently took it upon myself to create my own and as you'll see I got a little carried away  Read more...
By Additional Articles 2009/05/15 | Source: MSSQLTips.com | Category: String Manipulation
Rating: (not yet rated)  Rate this |  Briefcase | 1,617 reads

Function to return proper case

This function returns the proper case of any given string.   Read more...
By Sean Cooperman 2009/03/19 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 759 reads

TEXT/NTEXT Find and Replace

Find And Replace any string, in the entire table with this function. Parameterized for easy use.   Read more...
By Lowell Izaguirre 2009/02/26 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: (not yet rated) |  Discuss |  Briefcase | 557 reads

SQL Server CLR function to concatenate values in a column

If a column is normalized, but the user really wants to see the values as a short comma separated list, how can I write a query that produces the list? Concatenating the values in a column would be pretty easy if SQL Server had a concatenate aggregate function, which it doesn't. What's more, for efficiency sake it's important to write the reporting queries without using cursors.  Read more...
By Additional Articles 2009/02/09 | Source: MSSQLTips.com | Category: SQLCLR
Rating: (not yet rated)  Rate this |  Briefcase | 278 reads

Yet Another Pad Utility

A useful user defined function for padding values from the left or right with any token, number, or character.   Read more...
By Mike DiRenzo 2008/11/07 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 617 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...
By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 1,733 reads

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 822 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...
By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 2,055 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.  Read more...
By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 859 reads

Faking Arrays in Transact SQL

It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.  Read more...
By Additional Articles 2008/09/24 | Source: SimpleTalk | Category: T-SQL
Rating:  Rate this |  Briefcase | 4,742 reads

Create a single string from an entire table

I have a need to pass an entire table of data as a parameter to a COM+ component. I found that a simple XML call did the job.  Read more...
By Mike Bennett | Source: SQLServerCentral.com | Category: XML
Rating: (not yet rated) |  Discuss |  Briefcase | 329 reads

Create string from table

This simple script retrieves a range of values from a table and presents the results as a string.  Read more...
By Dave-261540 2008/09/15 | Source: SQLServerCentral.com | Category: Coalesce
Rating: |  Discuss |  Briefcase | 1,100 reads

Patindex

This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.  Read more...
By Manie Verster 2008/09/11 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 8,228 reads

Using XML to Enhance the Performance of String Manipulations

This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.  Read more...
By Wayne Sheffield 2008/08/20 | Source: SQLServerCentral.com | Category: XML
Rating: |  Discuss |  Briefcase | 8,600 reads
   Items 1 to 20 of 35    Next 20 >>
 
Most popular

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...
By Divya Agrawal 2009/06/25 | Source: SQLServerCentral.com | Category: XML
Rating: |  Discuss |  Briefcase | 8,990 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.  Read more...
By Carl P. Anderson 2009/10/14 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 13,303 reads

Using XML to Enhance the Performance of String Manipulations

This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.  Read more...
By Wayne Sheffield 2008/08/20 | Source: SQLServerCentral.com | Category: XML
Rating: |  Discuss |  Briefcase | 8,600 reads