how to adjust the column width for a result set?

[bhakhra]

Hi all,
I am retriving two columns and the result set is not fitting on the screen due to a wider column width..how can get rid of the extra spaces in between the two columns...

[docdiesel]

Hi,

if I understand you right you're displaying two columns with usually a couple of chars and lots of white space in between? You could cut them into place with substr() :

SELECT
  substr(name,1,20)    as name,
  substr(comment,1,60) as comment
FROM
  ...

Regards,

Bernd

[bhakhra]

Hi,

if I understand you right you're displaying two columns with usually a couple of chars and lots of white space in between? You could cut them into place with substr() :

SELECT
  substr(name,1,20)    as name,
  substr(comment,1,60) as comment
FROM
  ...

Regards,

Bernd

thats exactly what I was looking for..
thank you very much,

Sunny