InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:45:30 GMT20http://www.sqlservercentral.com/Forums/Topic572415-149-1.aspx[quote][b]avani104 (9/19/2008)[/b][hr]In the query below:FieldValueID-nvarchar(50) [since it can hv comma separated values 1,2]ID - intSelect CountryName from EYARDMasterCountry where ID in (FieldValueID)but this give an error...how do i read the values..pls lemme kno[/quote]Search for Array+SQL Server in googleFri, 19 Sep 2008 07:57:26 GMTMadhivanan-208264http://www.sqlservercentral.com/Forums/Topic572415-149-1.aspxFor better, quicker answers, click on the following... [url]http://www.sqlservercentral.com/articles/Best+Practices/61537/ [/url] (Thanks Jeff)You could CAST the [ID] as a varchar.Fri, 19 Sep 2008 05:40:06 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic572415-149-1.aspxIn the query below:FieldValueID-nvarchar(50) [since it can hv comma separated values 1,2]ID - intSelect CountryName from MasterCountry where ID in (FieldValueID)but this give an error...how do i read the values..pls lemme knoFri, 19 Sep 2008 05:27:19 GMTavani104