Re: Unwanted Pading

? What is the SELECT statement exactly - please cut and paste it for analysis (?)

• Martyn Cavett Senior ORACLE Analyst LGT Asset Management London, UK. home: cavett_at_globalnet.co.uk work: Martyn.Cavett_at_gtplc.com

These views are my own and not those of my employer. Normal conditions apply.

Guna Govind <guna_at_gwcom.com> wrote in article <338485B3.5060_at_gwcom.com>...
> Hi all
> the SELECT returns VARCHAR2 columns padded with BLANK characters
> which i don't want. I don't want to use RTRIM also as my input might
> have spaces at the end, which i don't want RTRIM to remove.
>
> Basically all i want is, the SELECT should return me what i
> entered as input and NO padding.
>
> I'd appreciate if you send an e-mail also.
> thanks
> Guna Govind
> ----------------------------------------------------------------
> | General Wireless Comm. Inc. | email: guna_at_gwcom.com |
> | 3350 Scott Blvd. Bldg# 36 | phone: (408) 986 8988 Ext.128 |
> | Santa Clara, CA 95054 | pager: (408) 581 4268 |
> | | page-mail: 1617196_at_pagemart.net |
> ----------------------------------------------------------------
>
  Received on Mon May 26 1997 - 00:00:00 CEST