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%C3%A9%20Freitas's gravatar image

André Freitas
1964510
accept rate: 0%

I have reproduced this and will investigate.

(02 Oct '12, 16:55) Chris Keating

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.

permanent link

answered 06 Nov '12, 11:12

Andy%20Quick's gravatar image

Andy Quick
2.2k2737
accept rate: 45%

Thanks Andy, much appreciated!

(12 Nov '12, 13:33) André Freitas
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×145
×49

question asked: 01 Oct '12, 16:25

question was seen: 783 times

last updated: 12 Nov '12, 13:33