I forgot to add..

SQLservercentral.com is simply superb (forums as well as the news letter). Thank u folks out there for doing a gr8 service.

First of all  I indeed thank both of you for a good amount of response.

Going through ur rreplies I constructed solution to my problem and David Burrows 1st response gave me most of...

Here is the table definition:

Here is sample data:-

I want 'rank' to be a computed column giving the rank of the...

yes, If i understood ur question correctly, there are more selects than updates on this table which is the backend for an asp page.. But I can not tell the...

Yes, I agree It would be extremely simple if we display the whole table.

However the problem is to show each user only his rank after a login through a webpage...

Ok OldHand thankyou. I have solved the problem by checking the length of the string in the supposed to be null field. It has shown zero length. Then I created...

Thanks Old Hand for Quick response.I agree that empty string is not null. I am checking. When I am posting only one record, two records are getting posted. One of them is...