Top "Isnull" questions

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

ISNULL function in SSIS

I have a column PhoneNumber varchar(50) and i want to build an expression for a derived column PhoneNumberType varchar(50) based …

sql-server unicode ssis isnull non-unicode

nvl is not a recognized built-in function name

I am executing below query on SQL Server but getting error: SELECT DISTINCT t1.p_id "Id", (TO_CHAR("sysdate", …

sql-server function built-in isnull nvl