I have a varchar field which has date information (came from access, DTS
didnt get along with the file for some reason) and it has trailing zeros.
How can I tell it to remove these zeros in the display? Th date is formated
as 7/26/2001 0:00:00
select field1, date(Cast as ?), field2 from tblname order by field1