good chemistry is complicated,
and a little bit messy -LW
I have to disagree with you.
The fact the data is coming from a database is very
relevant and key to the solution to this problem.
Instead of trying to output the data coming from the query:
select * from $table... I decided to deal with the formatting of the output
in SQL like so ...
select $cols from $table... where $cols is built up with ltrim, rtrim and ||
and the previous query. $cols for this particular
example would look like this ...
ltrim(rtrim(VALUE)) || '|' || ltrim(rtrim(DESCRIPTION)) || '|'Thanks for your input anyways.
Sorry your meta-help couldn't of been of more use.