Top "Isnull" questions

`ISNULL` is a SQL function that replaces NULL with the specified replacement value.

How does Left Join / IS NULL eliminate records which are there in one table and not in the other?

I am having a tough time to understand why does LEFT JOIN / IS NULL eliminate records which are there in …

mysql sql left-join isnull
How to encapsulate IIF and ISNULL call in Access 2010 VBA?

I use the following expression pattern in my Access 2010 database frequently: IIF(ISNULL(fieldName), Null, myFunction(fieldName)) Here myFunction is …

ms-access vba isnull iif
SQL Server NULL Integer to Empty String using ISNULL

My curiosity always gets the best of me and I've searched online for an explanation to this and came up …

sql sql-server tsql string isnull
Scala Check optional string is null or empty

I am a newbie to Scala and I want to learn how can I add null and empty check on …

java scala nullpointerexception functional-programming isnull
Oracle ORA-01722: invalid number Error because of WHERE IS NULL Condition

I have the following SQL: Select MyNumber FROM (SELECT to_number(Name) AS MyNumber FROM TableA WHERE regexp_replace(Name, …

sql oracle isnull
Why is T-SQL ISNULL() truncating the string and COALESCE is not?

Given the following: SELECT ISNULL('XY' + NULL, 'ABCDEFGHIJ') -- Outputs ABC (Why?) SELECT COALESCE('XY' + NULL, 'ABCDEFGHIJ') -- Outputs ABCDEFGHIJ …

sql-server tsql coalesce isnull truncation
mysql if not null, 0 or ""

SELECT * FROM table WHERE id IN ('21') AND (content_id IS NULL OR content_id = 0 OR content_id = '') …

mysql isnull
Convert INT column values to an empty string using ISNULL

I need to convert column ID of INT data type to a empty string ['']. I should not modify the …

sql sql-server-2008 type-conversion isnull