[Gambas-user] formatted output out of sql

[Tim Hanschen]

Hi,

I do an select (SELECT CONCAT(album,'     ',singer,'     ',titel) from mp3 order by album) on a mysql database.... so far so good. the result looks like that:

first_album     first_singer     first_title
second_album     second_singer      second_title

I want to format the output so that it looks a bit better:

first_album           first_singer          first_title
second_album     second_singer     second_title

Can I edit the select-command so that the result is formatted?

regards,
  - Tim -

____________________________________________________________________
Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Sober.A-F!
Kostenfrei fuer FreeMail Nutzer. http://f.web.de/?mc=021158