Re: Spaces in Oracle fields

In article <3c5pl2$bvf_at_wabbit.cc.uow.edu.au>, Rev Dr Phil Herring <revdoc_at_wumpus.cc.uow.edu.au> says:
>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 = null
> where
> bar is not null
> and
> ltrim(bar) is null;

update foo set bar=rtrim(bar);

>>In the longer term I need to prevent users from filling a
>>screen field with spaces only.
>The same logic applies...

Forms automatically does this anyway.

 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~