hi,

thanks , You were right with the Query u suggested.

The reason i wasnt getting when i tried the above method (infact several other ways) was due to inconsistent data.

Thanks for...

thanks Mr. or Ms.500

you were right....

Here is the Answer:

According to the error message, I had statistics created on the column, i needed to drop the existing statistics first:

http://msdn.microsoft.com/en-us/library/ms175075.aspx

Secondly,...