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.
Finding Near-Duplicate Rows With REGEXP_REPLACE
Find near-duplicate rows with SQL Server 2025 normalization, group matching labels, rank survivors, and preserve originals for review.
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.
Find Rows With Single Quotes in SQL Server: SQL in Sixty Seconds #075
To find rows with single quotes, write the quote twice inside the search string. This post tests four search patterns on one million rows on SQL Server 2025, shows which two are the same query and which one costs more, and covers the curly quote that a straight quote search misses.