Maybe you have some problem with your DataBase Desing. I can't understand
that (tow Fields Empty). One of both is not necesary.
Ask your self that:
1. They are necesarys?.
2. Can i merge my two field in one.?
3. Is most faster the querys with the concatenate fields.
4. I need that information on mi DataBase.

Ok, if your answer to that (4) question are true your Fields need the
property NOT NULL in the Fiel properties


Some fields like you have, t

----- Original Message -----
From: "A6-CMO Philippe Makowski" <makowski@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, October 16, 2002 09:17 AM
Subject: [ib-support] Null and Concatenate


> I have to concatenate some fields
> SELECT FIELD1 || FIELD2 AS TOT FROM MYTABLE;
>
> But sometimes FIELD1 or FIELD2 is NULL
> how can I do for having TOT not NULL in this case ?
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>