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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-15 : 09:40:32
|
Kay writes "Hello experts!
I am new to T-SQL, and have been beating my head against a wall with this one. I am trying to create a Stored Procedure that has the following line in it: WHERE NOT ISDATE(SpecialCharges.BilledOn). I keep getting either error 170 (if there are no other conditional statements included) or error 156. It appears to be choking on the "BilledOn" somehow. This particular column is not required so there are some null values. This does run in Access without a glitch. And using the COALESCE, or COALESCEEMPTY fuctions do nothing.
Help!
Thanks,
Kay" |
|
|
|
|
|
ISDATE function