I have a customer with a CHAR field that contains "YYYYMMDDHHMMSS". If I want to dumpspecified the past 2 years, is it sufficient to say:
_proutil db -C dumpspecified table.chardate GE "20120910000000"
Yes there is an index on the field.
I'm looking for GOTCHAs. I understand that if the data is dirty then I risk garbage in - garbage out. Am I wrong to believe that the CHAR field will sort correctly?
Paul