Tag: CAST

Objective-C Tutorial – Lesson 4: Part 2: Cast Operator & Sizeof Operator


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

Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server

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.

Continue reading “Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server”