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.
ISNUMERIC Puzzle: SQL in Sixty Seconds #076
The ISNUMERIC puzzle hides a tab character. Tests on SQL Server 2025 show which strings pass ISNUMERIC but fail TRY_CONVERT, how an empty string and a lone minus sign convert to 0, and how to find control characters in imported data with a short query.