Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jon3k
Starting Member
49 Posts |
 Posted - 2005-05-26 : 14:26:43
|
| The following just isn't working as I expected:SELECT * FROM TableWHERE NOT isDate(Field)I assumed this to return all records from "table", where "Field" is not a valid date value.Instead, I get: Incorrect syntaxt near ')' |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-26 : 14:28:46
|
| SELECT * FROM myTable99 WHERE ISDATE(Column) = 0Brett8-) |
 |
|
|
jon3k
Starting Member
49 Posts |
Posted - 2005-05-26 : 14:31:26
|
now why didn't I think of that.  especially since I tried select isdate(field) and saw that it returned a boolean value. Doh!Told you it was easy! Thanks! |
|
|
|
|
|
|
Easy one - determine which values in field isDate(