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

Scripts with tags T-SQL, String Manipulation Rss

Search for any content tagged t-sql & string manipulation

Add a script

   Items 1 to 11 of 11   
 

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 | 852 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: |  Discuss |  Briefcase | 636 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,831 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 | 863 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 | 905 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...
Rating: |  Discuss |  Briefcase | 736 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,203 reads

String Tokenizer with Complex Search

Sample solution to replace string in expressions with multiple delimiters.  Read more...
By tsaftalov 2008/01/31 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |  Briefcase | 1,783 reads

Split by Row & Field delimitters

Like my tdard split but this will take a string and split it by 2 delimiters  Read more...
Rating: |  Discuss |  Briefcase | 1,351 reads

Find occurence of any value in database!

Search entire database for occurrence of any text!  Read more...
By Reddy Software Solutions 2007/12/31 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |  Briefcase | 3,256 reads

Function to expand tab characters

A function to replace tab characters with the correct number of spaces to align the text as originally intended.  Read more...
By Phil Factor 2007/12/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 1,468 reads
   Items 1 to 11 of 11