Hi there,

I'm still on 2.30B4 so maybe this is already fixed, but could someone try:

--

create table test(txt varchar(100))

insert into test values ('a')

insert into test values (null)

select txt, coalesce(txt, 'null') from test

--

I'm not getting the 'null' string in the expression...

Cheers,

Heiko

Ah, nevermind, I found it. 'null' as a string confuses the engine.

Sorry.