Hello abyss,

Check out the built-in function COALESCE which will do your special-casing for you

Tuesday, December 18, 2007, 3:16:31 AM, you wrote:

>	I don't know if it's bug or feature but select 'test' \|\| null as result returns null, so i need to case second parameter not to concat if it is null...

Best regards,