Removing blanks from ouput format ?
As long as it doesn't exceed 255 characters, and assuming varchars, you
could do the select like this:
select a+" "+b+" "+c as "A B C" from T1.
If the columns are char types:
select rtrim(a)+" "+rtrim(b)+" "+rtrim(c) from T1
-bret
Quote:
> Hi all,
> is there a way to discard the blanks filling a column in SELECT ?
> I wish I could have
> select * form T1
> A B C
> ------ -------- ------
> 1 2 3
> 4 50 7
> a b cd
> instead of:
> select * form T1
> A B C
> ------ -------- ------
> 10 2 3
> 4 50 7
> a b cd
