e] Re: Re: combination of fields with || ?
Daniel Schumann <[EMAIL PROTECTED]> wrote:
what do i have to do if i want to add another string after F1 if F2
is not null e.g. ' ,' ?
select ifnull(f1, '') ||
(case when f1 and f2 then ', ' else '' en
qlite] Re: combination of fields with || ?
Daniel Schumann <[EMAIL PROTECTED]> wrote:
i try to combine two fields in a query like: SELECT id, F1||F2 AS
FNew, F3 ... when both fields F1 and F2 got data everything is ok but
if one of the fields is empty, the whole field FNew is empty :-(
Hello,
i got a table 't' with two fields for example :
Lastname | Name
-
Duck | Donald
| Peter
with :
SELECT * FROM t WHERE (Lastname='Duck') AND (Name='Donald')
everything is all right
with :
SELECT * FROM t WHERE
Hello,
i try to combine two fields in a query like: SELECT id, F1||F2 AS FNew, F3 ...
when both fields F1 and F2 got data everything is ok but if one of the
fields is empty, the whole field FNew is empty :-(
how can i solve that problem ?
thx
4 matches
Mail list logo