SQLServerCentral.com Content tagged T-SQL Aids, String Manipulationhttp://www.sqlservercentral.com/Content tagged T-SQL Aids, String Manipulation posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Delimited String Parsing Functions - TwoCol setFeed 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/Delimited String Parsing Functions - Big2D setFeed 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/Delimited String Parsing Functions - Basic SetFeed 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/Delimited String Parsing Functions - 2D setFeed 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/Delimited String Parsing Functions - Big SetFeed 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/Trim Trailing Blanks in SQL QueriesReformats 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/