SQL return all rows concatenated?
From: Colin Jones <seajays_at_hotmail.com>
Date: 6 Sep 2001 08:36:16 -0700
Message-ID: <5e2ca337.0109060736.1cab955c_at_posting.google.com>
Date: 6 Sep 2001 08:36:16 -0700
Message-ID: <5e2ca337.0109060736.1cab955c_at_posting.google.com>
Is it possible for an SQL query that would normally return a number of rows, to instead return the row results as a single field, concatenated?
So:
SELECT SOMEFIELD
FROM SOMETABLE
Gives 3 rows:
MONDAY
WEDNESDAY
FRIDAY
Instead I want to return - as one field in one row:
MONDAY WEDNESDAY FRIDAY
Received on Thu Sep 06 2001 - 17:36:16 CEST