how to solve this problem

but my sql server 2008 its show error

Invalid length parameter passed to the RIGHT function.

Luis Cazares (10/20/2015)

---

Alan, your idea is good, but if order is important a tweak might be needed.

CREATE FUNCTION dbo.RemoveDupes(@string varchar(8000))

RETURNS TABLE AS

RETURN

WITH CTE AS(

SELECT...

thanks for your answer ,...

Sir, i am junior developer i am learning sql server, your professional i need only help..:crying:

Alan.B (10/20/2015)

---

mr.addikhan (10/20/2015)

---

Alan.B (10/20/2015)

---

I would suggest taking what I posted (or what Luis posted if...

i am using SQL Server 2008

step 1 : i am create your posted function like this

CREATE FUNCTION dbo.RemoveDupes(@string varchar(8000))

RETURNS TABLE AS RETURN

SELECT NewString =

(

SELECT DISTINCT empaddress+'...

Alan.B (10/20/2015)

---

I would suggest taking what I posted (or what Luis posted if order is...

can u please tell me in detail because , its important for me..

i have three column , empid , empname, empaddress

empaddress data :''BLACKHEATH 0AA ...

its not working 🙁 my tbl name is tblemp column name is empaddress