On Tue, June 3, 2008 16:05, SenTnel wrote:
> Hi all!
> My database has a lot of empty fields in the "street" column, meaning that
> lot of streets has no name registered, they're just plain blank.
> What I would like to do is to INSERT something like "N/A" (Not Available)
> every field that is empty in the "street" column, but don't know exactly
> SQL statemet to tell:
> "In mytable, street column, insert 'N/A' in every empty space"
update mytable set street='N/A' where (rtrim(street)='' or street is NULL)
I always do a
select * from mytable where (rtrim(street)='' or street is NULL) limit 10
as a test first.
William R. Mussatto