January 9, 2007 at 2:14 pm
Hi,
I run this query and get these error results
begin
tran
Update
lsexceptions set workedby = 'dskuhrovec' where clearedate = 'Blank' AND loannum >='999824 <=1000085'
rollback
tran
error received
Msg 241, Level 16, State 1, Line 2
Conversion failed when converting datetime from character string.
anyone know how I can fix this?
thanks,
January 9, 2007 at 2:29 pm
>>where clearedate = 'Blank'
What datatype is the [clearedate] column ? If it's a datetime, you can't compare it to the text 'blank'.
Did you mean this:
WHERE clearedate IS NULL
January 9, 2007 at 2:42 pm
The cleardate is a date time
January 9, 2007 at 2:50 pm
2nd part of the reply was :
Did you mean this:
WHERE clearedate IS NULL
January 9, 2007 at 2:59 pm
Yes NULL is the magic word. Thanks so much. You guys are great!
January 9, 2007 at 10:15 pm
You need to fix this too: loannum >='999824 <=1000085'
loannum
Between '999824' And '1000085'
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply