very good script practice question for beginners like me. I really love the answers.

Please try the following, I am also learner, please tell me if any thing wrong in my query, as per my tests it is giving correct results.

Select studentId,

casewhen percentage>=0 and...

Thank you Nabha. You made sound points.

I think the following is the better code to split the string seperated by comma.

Declare @inputString varchar(1000)

set @inputString='1,2,3,5,6,7,8'

while(charindex(',',@inputString)>0)

begin

print substring(@inputString,1,charindex(',',@inputString,1)-1)

set @inputString=stuff(@inputString,1,charindex(',',@inputString,1),'')

end

I could not get you Sir!