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. asked 01 Oct '12, 16:25 André Freitas |
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. answered 06 Nov '12, 11:12 Andy Quick Thanks Andy, much appreciated!
(12 Nov '12, 13:33)
André Freitas
|
I have reproduced this and will investigate.