| Column value (varchar) | ISDATE return value |
|---|---|
| NULL | 0 |
| Abc | 0 |
| 100, -100, 100 a, or 100.00 | 0 |
| .01 | 0 |
| -100.1234e-123 | 0 |
| .231e90 | 0 |
| $100.12345, - $100.12345, or $-1000.123 | 0 |
| as100 or 1a00 | 0 |
| 1995-10-1, 1/20/95, 1995-10-1 12:00pm, Feb 7 1995 11:00pm, 1995-10-1, or 1/23/95 | 1 |
| 13/43/3425 or 1995-10-1a | 0 |
| $1000, $100, or $100 a | 0 |