Showing posts with label product_tblcolumn. Show all posts
Showing posts with label product_tblcolumn. Show all posts

Monday, March 12, 2012

repeated words retrival

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.Question moved to SQL Server Forum from the Articles section.