Thanks!

When I CAST the text field as a VARCHAR(MAX) I was able to locate the duplicate text field values.

WITH cte AS (

SELECT a.*,

ROW_NUMBER() OVER(PARTITION BY [varcharfield],CAST([textfield]...

Nice post! I have a problem looking for duplicates in a similar table with "text" fields. What would that SQL look like?

Thank you,

Bob