Thanks for ur response.

I have only one column and that is of varchar data type.That is the main problem.SO can u tell me how to do this for varchar data...

Hey i wanted to still enhance this requirement,Now my requirement is that I have the table two columns.one is number with values of 1 or 2 and the name with...

Thanks.It's working fine