Understanding Date Select Queries: Uncovering the Mystery of Between Clauses

How to Properly Increment Auto-Incrementing Primary Keys Stored in VARCHAR Columns Using SQL