Hi list,

suppose I have two fields f1 and f2, of varchar type that can have null values. If I make a query like:

select f1 || f2 from table

the records where f1 is not null and f2 is null, the result is null, but I want the result to be f1 (the field which is not null).

How can I make this? The Interbase documentation doesn't explain this.

Jordi

[Non-text portions of this message have been removed]