RE: SQL Server and Nulls

2015-04-17 Thread DURETTE, STEVEN J
Dbfield= Steve -Original Message- From: Robert Harrison [mailto:rharri...@aimg.com] Sent: Friday, April 17, 2015 3:58 PM To: cf-talk Subject: SQL Server and Nulls In an update query, to a tinyint field which allows nulls, I have the update dbfield=#mydatefield# If mydatefield has

Re: SQL Server and Nulls

2015-04-17 Thread John M Bliss
dbfield = On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison wrote: > > In an update query, to a tinyint field which allows nulls, I have the > update > > dbfield=#mydatefield# > > If mydatefield has no value, sql is throwing an error. The field allows > nulls. I've never had to say if "" then N

SQL Server and Nulls

2015-04-17 Thread Robert Harrison
In an update query, to a tinyint field which allows nulls, I have the update dbfield=#mydatefield# If mydatefield has no value, sql is throwing an error. The field allows nulls. I've never had to say if "" then NULL before. What the heck? Robert Harrison Full Stack Developer AIMG rharri...@ai