I think you have comma separated values in a field named 'LANGUAGES'...GOCREATE FUNCTION [dbo].[CustomSplit] (@sep char(1), @s varchar(512))RETURNS tableASRETURN ( 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 sFROM Pieces)GOselect l.LANGuage from M_Language l where l.LID in(SELECT s FROM details CROSS APPLY [dbo].[CustomSplit](',',languages) WHERE memberid='000005')
--Chandu