I have a column like product name where in i want to retrive repeated words in the same row.
Ex:
Table Name: product_tbl
Column Name: productname
data: xyz and abc and ltd
Here the word and is repeated twice.
please provide query for retrive these type of cases.Question moved to SQL Server Forum from the Articles section.