GO
CREATE FUNCTION [dbo].[CustomSplit] (@sep char(1), @s varchar(512))
RETURNS table
AS
RETURN (
	WITH Pieces(n, start, stop) AS (
	SELECT 1, 1, CHARINDEX(@sep, @s)
	UNION ALL
	SELECT n + 1, stop + 1, CHARINDEX(@sep, @s, stop + 1)
	FROM Pieces
	WHERE stop > 0
)
SELECT n,
SUBSTRING(@s, start, CASE WHEN stop > 0 THEN stop-start ELSE 512 END) AS s
FROM Pieces
)

GO
select l.LANGuage 
from M_Language l 
where l.LID in(SELECT s 
		FROM details
		CROSS APPLY [dbo].[CustomSplit](',',languages)
		WHERE memberid='000005')

select l.LANGuage 
from M_Language l 
INNER JOIN details d
ON ',' + d.LANGUAGES + ',' LIKE '%,' + CAST(l.LID AS varchar(10)) + ',%' 

quote:

---

Originally posted by visakh16

best way would be to resolve many to one relationship by means of intermediate table which has languageid against memberid stored as rows instead of delimited format

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by svibuk

quote:

---

Originally posted by visakh16

best way would be to resolve many to one relationship by means of intermediate table which has languageid against memberid stored as rows instead of delimited format

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

Thanks for pointing out the normalization error which i had
i have done accordingly
but the issue is when i am displaying the records in a label control , i need it as delimited

---