Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Ive been using the IsNull function but it seems to be ignoring the second parameter (just returning True or False instead). Is this function supported and/or is there an alternative?

April 26, 2017False function ignoring isnull parameter returning supported

0

Posted

Ive been using the IsNull function but it seems to be ignoring the second parameter (just returning True or False instead). Is this function supported and/or is there an alternative?

1 Answer

0

Posted

Officially SQL Server Compact Edition doesn’t support IsNull, although the described behaviour is accurate despite not throwing a parse error or being documented. The supported function is Coalesce which behaves in a similar fashion, returning the first non-null argument.