thanks folks...i have done this with "max" and got the desired results.

thanks again

GRN

This is ok as i also write in my earlier post. but when i uses this with my column name then it gives error say my column name is...