SQL Server Central 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 (5)     T-SQL Aids (1)     XML (1)    
Administration (1)     UDF (1)     XQUERY (1)    
Search (1)     User Defined Function (1)    
   Items 1 to 10 of 10   
 

SQL String User Function Workbench: part 1

Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.  Read more...
By Additional Articles 2008/04/22 | Source: SimpleTalk | Category: T-SQL
Rating:  Rate this |  Briefcase | 2,982 reads

Padding function

Function that helps you to normalize numbers or strings.  Read more...
By Francis Jamet 2008/04/21 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 761 reads

Find and Replace a String in the Whole Database

Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database   Read more...
By Luiz Barros 2008/04/11 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 1,256 reads

Trim Trailing Blanks in SQL Queries

Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.  Read more...
By Jesse McLain 2008/03/10 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 1,101 reads

Get given character's position from a string

Get given character's position from a string  Read more...
By hxd001_810 2008/02/13 | Source: SQLServerCentral.com | Category: User Defined Function
Rating: |  Discuss |  Briefcase | 700 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 | 737 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 | 1,559 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 | 844 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 | 709 reads

XML Workshop XII - Parsing a delimited string

Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.  Read more...
By Jacob Sebastian 2007/12/05 | Source: SQLServerCentral.com | Category: XML
Rating: |  Discuss |  Briefcase | 3,488 reads
   Items 1 to 10 of 10   
 
Most popular

SQL String User Function Workbench: part 1

Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.  Read more...
By Additional Articles 2008/04/22 | Source: SimpleTalk | Category: T-SQL
Rating:  Rate this |  Briefcase | 2,982 reads

XML Workshop XII - Parsing a delimited string

Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.  Read more...
By Jacob Sebastian 2007/12/05 | Source: SQLServerCentral.com | Category: XML
Rating: |  Discuss |  Briefcase | 3,488 reads

Find and Replace a String in the Whole Database

Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database   Read more...
By Luiz Barros 2008/04/11 | Source: SQLServerCentral.com | Category: String Manipulation
Rating: |  Discuss |  Briefcase | 1,256 reads