Need to find strings with same characters, like KKK but not KKT? Here is a simple trick using REPLACE and LEFT, with no WHILE loop needed.
SQL SERVER – Reverse String Word By Word Part 4
In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.
SQL SERVER – Reverse String Word By Word Part 3
Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.
SQL SERVER – Reverse String Word By Word Part 2
In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.
SQL SERVER – Reverse String Word By Word
A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.
SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick
A reader wanted students and courses grouped by course and instructor in a single row. Here is a simple concatenation trick with XML PATH that does it.
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
A friend building a captcha had to skip words that read the same backward. Here is a T-SQL script with REVERSE to check if a string is a Palindrome.