repeated words retrival

[phanigamini]

Hi,

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.

[debasisdas]

Question moved to SQL Server Forum from the Articles section.