Hi I tried the above code with a small change, I declared the datatypes of the variable as varchar(max), but the output i am getting is wrong. I didn't understand what the problem is. When it is given size as 100 it is working correctly. Can you please help me. I want be more clear regarding this. The input string I provided is 'sireesha' and the output I am getting as 'a'.
Thanks in advance,
commented on May 3 2013 4:12AM