cancel
Showing results for 
Search instead for 
Did you mean: 

Weird ISNULL behavior in Ultralite

Former Member
2,019

Hi again.

I have found a strange behavior when placing two ISNULL functions together, like in the following example:

SELECT ISNULL('a','') + ISNULL(NULL, '') + 'b'

I suppose the correct result is 'ab', however Ultralite returns only 'b'. Note that I left both isnulls with an empty string in the second parameter. If I replace it with a space or any other character:

SELECT ISNULL('a','x') + ISNULL(NULL, 'x') + 'b'

Then it returns 'axb' correctly.

chris_keating
Product and Topic Expert
Product and Topic Expert
0 Kudos

I have reproduced this and will investigate.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

This problem has been fixed. See engineering case 723443, in the next EBF (build 12.0.1.3815 or greater). Thank you for the report.

Former Member
0 Kudos

Thanks Andy, much appreciated!

Answers (0)