Hi friends, i am executing this query in sql server 2005 select * from users where (primaryemail like 'brijesh%@efextra.com') order by firstname and it's working well.but when i tried this one select * from users where (primaryemail like 'brijesh%@efextra.com') group by firstname it's shows me error, why? i am not getting the reason