I wrote a simple query:

SELECT u.FirstName, u.LastName, u.DisplayName, u.Email, up.PropertyValue
FROM UserProfile AS up
INNER JOIN Users AS u ON u.UserId = up.UserId
Where PropertyDefinitionID=78
ORDER BY up.PropertyValue ASC

The problem is the ORDER BY up.PropertyValue ASC is a date field and it is not sorting correctly.

Here is the result:

3/11/2010
3/18/2009
3/27/2009
3/28/2009
3/29/2008
3/30/2010
3/31/2008
5/22/2009
8/31/2008
8/31/2009
9/11/2008

Any ideas?

Thanks,

Mike

Hey thanks Sonny. Worked like a charm!

Just another silly question. Is it possible to change the headers of the columns.

For instance, to say First Name instead of FirstName or Expiration Date instead of PropertyValue?

Thanks again for your help,

Mike

Thank you so much Klaus!

You really help make my report make more sense.

Thanks again,

Mike