Re: [sqlite] Concatenation question

Clark Christensen wrote: > > Long setup for a simple question: Is null the expected result when > one column of a concatenation operation is null? > Yes, that is the result required by the SQL standard. The result of a concatenation operator is NULL if either argument is NULL. HTH Dennis Cote

Re: [sqlite] Concatenation question

Clark Christensen <[EMAIL PROTECTED]> wrote: > Long setup for a simple question: Is null the expected result when > one column of a concatenation operation is null? Yes. Pretty much any operation where at least one operand is NULL produces a NULL. See also http://sqlite.org/nulls.html Igor Tand

[sqlite] Concatenation question

Hello, Using SQLite v3.3.13, this query: select oid || '|' || email_addr || '|' || residual_value as RD from gl_claims c where --RD is not null and status = 1 and not exists (select 1 from gl_claim_tickets where ticket_type = 'coupon' and claim_id = c.oid); I expect one ro