http://www.sqlservercentral.com/Content tagged String Manipulation posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/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.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/Feed it delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/This simple script retrieves a range of values from a table and presents the results as a string.http://www.sqlservercentral.com/scripts/Coalesce/63733/2008/07/16http://www.sqlservercentral.com/scripts/Coalesce/63733/This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.http://www.sqlservercentral.com/articles/XML/63633/2008/08/20http://www.sqlservercentral.com/articles/XML/63633/Feed it large strings of delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/Simple script overcomes the 8000 character limitation in the T-SQL print Commandhttp://www.sqlservercentral.com/scripts/Print/63240/2008/07/28http://www.sqlservercentral.com/scripts/Print/63240/To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.http://www.sqlservercentral.com/articles/T-SQL/63404/2008/07/21http://www.sqlservercentral.com/articles/T-SQL/63404/Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.http://www.sqlservercentral.com/redirect/articles/63204/2008/06/04http://www.sqlservercentral.com/redirect/articles/63204/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.http://www.sqlservercentral.com/redirect/articles/62836/2008/04/22http://www.sqlservercentral.com/redirect/articles/62836/Function that helps you to normalize numbers or strings.http://www.sqlservercentral.com/scripts/String+Manipulation/62479/2008/04/21http://www.sqlservercentral.com/scripts/String+Manipulation/62479/Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database http://www.sqlservercentral.com/scripts/String+Manipulation/62203/2008/04/11http://www.sqlservercentral.com/scripts/String+Manipulation/62203/Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.http://www.sqlservercentral.com/scripts/T-SQL+Aids/61896/2008/03/10http://www.sqlservercentral.com/scripts/T-SQL+Aids/61896/Get given character's position from a stringhttp://www.sqlservercentral.com/scripts/User+Defined+Function/61768/2008/02/13http://www.sqlservercentral.com/scripts/User+Defined+Function/61768/Sample solution to replace string in expressions with multiple delimiters.http://www.sqlservercentral.com/scripts/String+Manipulation/61685/2008/01/31http://www.sqlservercentral.com/scripts/String+Manipulation/61685/Search entire database for occurrence of any text!http://www.sqlservercentral.com/scripts/Search/61508/2007/12/31http://www.sqlservercentral.com/scripts/Search/61508/Like my tdard split but this will take a string and split it by 2 delimitershttp://www.sqlservercentral.com/scripts/String+Manipulation/61509/2007/12/28http://www.sqlservercentral.com/scripts/String+Manipulation/61509/A function to replace tab characters with the correct number of spaces to align the text as originally intended.http://www.sqlservercentral.com/scripts/T-SQL/61301/2007/12/14http://www.sqlservercentral.com/scripts/T-SQL/61301/Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.http://www.sqlservercentral.com/articles/XML/61618/2007/12/05http://www.sqlservercentral.com/articles/XML/61618/