Re: [SQL] Select CASE Concatenation

2006-07-07 Thread Aaron Bono
On 7/7/06, Phillip Smith <[EMAIL PROTECTED]> wrote: I have a SELECT statement, part of which is a "Flags" column which is a CASE function, but I need to be able to concatenate the results together. Example: in the below, I need to be show both "@" and "K" if both of the CASE blocks are true… Possib

[SQL] Select CASE Concatenation

2006-07-07 Thread Phillip Smith
Hi All – Smee again!   Two questions but they’re unrelated so I’ll make 2 posts to keep it clean!   Number one (and I think is the easier one)…   I have a SELECT statement, part of which is a “Flags” column which is a CASE function, but I need to be able to concatenate the results tog