howto ignore whitespace in select query

From: San Tuon (anonymous_at_discussions.microsoft.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 03:21:37 -0800

Hello.

I am getting unwanted whitespaces returned from a select
statement.

I understand my table definition has stated a "char" with
field length 10. However if my value stored is only 5
characters, how do I structure my select query to trim
extra 5 spaces returned in my query. It is possible?

ie "Select id from user"
returns "Santuon " instead of "Santuon".
I do not wish to trim the string afterwards.

Regards San.

Relevant Pages

  • Re: Using Flattened table COSTLIER than using JOINS with the SETUP tables.
    ... tables and also attaching the Explain plan statements for the query ... Next Execution plan without PSOPRALIAS:- is 13135 ... DECODE (TRIM (c.jp_draft_to_status), ...
    (comp.databases.oracle.tools)
  • Re: The Barrister and me and myself and I
    ... trim to that line only? ... That way the query and your reply jumps straight ... off the screen and smacks the reader between the eyes; ...
    (alt.usage.english)
  • Re: The Barrister and me and myself and I
    ... > you're responding to the last line only, that it would be sensible to ... > trim to that line only? ... That way the query and your reply jumps straight ... > letters, memos, novels, and see no reason why Usenet shouldn't receive ...
    (alt.usage.english)
  • Re: How to trim substrings?
    ... I know ltrim() or rtrimonly trim out one character/digit once. ... This must be done purely by SQL*Plus query. ... SQL> select ltrimfrom dual; ...
    (comp.databases.oracle.misc)