[sqlite] combination of fields with || ?

[Daniel Schumann]

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