In this lesson I demonstrate how you can change a variable from one type to another and how to find out for yourself the size of a variable in bytes. Twitter – twitter.com FaceBook – www.facebook.com E-mail – [email protected] Objective-C Tutorial objective-c tutorial objective c tutorial
In an SQL Server View, a problem is that the DateTime field has many Null values which is causing a problem with the parsing of the data in MSAccess.
How to I use CAST (or CONVERT) to handle Null Date values in my SQL Server view?
There is a way to use CAST or CONVERT similar to the nz type function in MSAccess to handle null date values but I can’t remember the syntax.
What is happening now is that I get a data mismatch in my MSAccess function when it hits a Null Date value. Can I somehow use the ISNULL or ISDate function? I believe I need to somehow return “” instead of Null.