Re: howto ignore whitespace in select query

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

Date: Fri, 26 Mar 2004 03:48:45 -0800

Thanks a million.

For future reference. Is there a way to structure the
database to automatically not return spaces.. ie, the
length of the field should be just the maximum allocated.
I noticed with MS access, the field length is the maximum
size,.. not a fix size. Is my understanding wrong?

Regards San.

>-----Original Message-----
>hi san,
>use function rtrim.
>
>select rtrim(id) from user
>
>--
>Vishal Parkar
>vgparkar@yahoo.co.in
>
>
>.
>

Relevant Pages

  • Re: Newbie needs help on setting up database!!!
    ... ensure the database do not die on me. ... and can most of the data entry be done ... putting multiple users in the database at the same time will test its' ... suggest you bookmark the following sites for future reference - and you will ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Move secured DB to shared folder, now it wont open
    ... are going to implement this database on a company network. ... I appreciate your suggestion, TC. ... > that for future reference, but I actually think it is more advanced than ...
    (microsoft.public.access.security)
  • RE: sp_attach_db (encounted problems after having Oracle installed)...
    ... future reference. ... Create a new database with the same name as the ... Start SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Auto Archiving
    ... I have a database which i have put a yes/no field to show when a tast ... record when exiting so that the record will no longer be visble but will be ... stored for future reference. ...
    (microsoft.public.access.forms)