Hi, I found that REPLACE builtin function return the empty string for NULL values.
Testcase: select val, trim(val) as trim_val, replace(val,',','.') as replace_val , REGEXP_REPLACE(val, ' +', ' ') as regreplace_val, instr(val,'@') as instr_val from ( select cast( null as varchar(10)) as val ) as x It's a bug or have some motivation ? regards, Dario -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
