Apr 16, 2010 10:39 AM|arefinn|LINK
Hi I am facing a problem. Suppose I have a table called Student.
Fields are :
StudentId IDENTITY(1,1) BIGINT
I want to select those student's details whose name are Abu and Arefin
My query is
WHERE StudentName IN ('Abu','Arefin')
This is working fine..Now I have a listbox in frontend in which student's name are there.So instead of hardcoding the name I want to send these name from front end in a single string variable by concatinating one by one and sending this as a parameter.
In this case my query doesn't return any result. Any guess why??!!