Monday, 9 September 2013

SQL - Find duplicate values and remove in a field

SQL - Find duplicate values and remove in a field

Consider a column named ArticleCategories in Article table. The goal is to
delete repeated numbers from ArticleCategories column for each row (.
ArticleCategories
------------
3193;2867;3193;
2871;2923;2923;
3278;3337;3337;
2878;2876;2878;
3720;3680;3680;
Any help on how I can get this done with SQL Server?
desired result
ArticleCategories
------------
3193;2867;
2871;2923;
3278;3337;
2878;2876;
3720;3680;
Thanks in advance if anyone could help.

No comments:

Post a Comment