Re: Spaces in Oracle fields

In article <3c6tdb$36c_at_cs3.brookes.ac.uk> Tommy Wareing, p0070621_at_brookes.ac.uk writes:
>>In article <1994Dec7.105815.22775_at_bilpin.co.uk> Tony Desborough,
 tony_at_bilpin.co.uk writes:
>>In the short term I need an SQL update statement
>>to set a field to NULL if it contains spaces (and only spaces).
>
>update foo set bar=rtrim(bar);

Close, but no doughnut. Read the specification again.

• Phil.

  ---

  (c) 1994 Rev. Dr. Phil Herring revdoc_at_wumpus.cc.uow.edu.au
  • Church of the Sacred Dial Tone, Wollongong, Australia - Unauthorised reproduction of this article for profit will result in civil action. All other distribution is encouraged.

    ---