• If you do decide to convert the dates to VARCHAR rather than BINARY, you need to convert it in a format that will sort correctly, such as YYYY-MM-DD hh:mm:ss.

    From several tests, it appears that both perform about the same, so it's likely that the author chose the binary string, because he didn't need to worry about which format to use for the conversion.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA