![](https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg)
Remove Duplicates from Delimited String in T-SQL
Use this snippet to remove duplicates from a delimited string: DECLARE @mystring varchar(1000), @myword varchar(50),@CachedStringvarchar(2000)set @CachedString=”DECLARE @i int,@j intSELECT @mystring = ‘cat dog fox cat chicken hen goose cat bird