Hi,
A query such as:
SELECT 'a' || 'b' || NULL;
returns a NULL. How can I ensure I get 'ab' in the result? I'm tryingto concatenate columns and one of them might have NULL values, which Isimply want to ignore.
Cheers,
-- Seb