zimmer9
asked on
How would you sort on a field defined as varchar(30) that stores dates (for ex: 01/01/2010) in SQL Server 2005 ?
I am trying to write a SQL statement to sort records in a table named tblDailyDeliver that has 2 fields.
The first field is OfficeNumber defined as nvarchar(4)
The second field is TodaysDate defined as varchar(30)
How would you write a SELECT statement to retrieve all records in table tblDailyDeliver by sorting on the field TodaysDate in DESC order that stores dates (for ex: 01/01/2010) while using SQL Server 2005 ?
The first field is OfficeNumber defined as nvarchar(4)
The second field is TodaysDate defined as varchar(30)
How would you write a SELECT statement to retrieve all records in table tblDailyDeliver by sorting on the field TodaysDate in DESC order that stores dates (for ex: 01/01/2010) while using SQL Server 2005 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.