On Thu, Aug 21, 2003 at 03:30:11PM +, Nick Heppleston wrote:
> I have a concatenation problem and I was wondering if somebody might be
> able to offer some help :-)
Hi Nick,
Your problem is a formatting problem, not a concatenation problem; i.e.
SQL concatenation wasn't intended to solve th
* Roger Baklund
[...]
> SET @a="";
> SELECT @a:=CONCAT(@a,' ',long_desc) FROM YourTable;
> SELECT @a;
Sorry, my test table only contained records for a single product... you
would need something like this:
SELECT @a:=CONCAT(@a,' ',long_desc)
FROM YourTable
WHERE pn = "HL1450"
ORDER BY seq;
* Nick Heppleston
> I have a concatenation problem and I was wondering if somebody might be
> able to offer some help :-)
I can try. :)
> I have the following table structure holding product long descriptions:
>
> Part No (pn)Sequence (seq) Long Description (long_desc)
> --
