Tame Those Strings (Series)

A series of articles that deal with string manipulation techniques.

Function - Word count in a sentence

The function (Inline function) is used to determine the word count in a textual/string input.
* Compatible from SQL Server 2012 and up.

Pad length

Pad string with a lenght of characters at front or back

Comparing string splitting / concatenation methods

Whenever a query is executed in SQL Server, its execution plan, as well as some useful execution data are placed into the plan cache for future use. This information is a treasure trove of metrics that can allow some very useful insight into your server’s performance and resource consumption - Ed Pollack shares some useful queries to start utilizing it.

Split string using multiple delimiters - version 2

http://www.sqlservercentral.com/scripts/split+string/117123/

The above script will split upto 256 char length only. This new version will split upto N length.

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.

A CONCAT Function For The Rest Of Us

SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.

Stored procedure to find and replace text in a text file

find and replace text in a text file using tsql

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.

String tokenizing / splitting

We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.