Re: Return trimmed string from the query

[Rob Sargent]

> Sorry for a late reply.
> 
> So does this mean that if I use varchar instead of char I will not
> have this problem?
> 
> Thank you,

Yes. If you use text rather char(n) you will not get space-padded values. 

If you have char(n) fields already you have work to do to irradiate them. It 
will be effort well spent though. 


> 
>> (1 row)
>> 
>> regards
>> 
>> Pavel
>> 
>>> 
>>> 
>>> Thank you.
>>> 
>>> 
> 
>