How to delete blank spaces on a field

[Gunter Abreu]

Hi all.

Let me try to explain me......

In a table I have a field (varchar type) named fe_baja, this fields contains in some records data, in others no.}

The problem is when i send to the server the next instruction.

select fe_baja from estructura where fe_baja is not null
or
select fe_baja from estructura where fe_baja != ''

the result show me all the fields, i supose tha the other fields have a blank spaces but i don't know how to set those records to null.

Some body can help me???

If somebody speaks spanish me too.

Thanks a lot.

Regards.