The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.1k2436
accept rate: 43%

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:

×128
×46

question asked: 01 Oct '12, 16:25

question was seen: 737 times

last updated: 12 Nov '12, 13:33