How to filter space character ??

[Jay Liam]

Hi folks,   I got one stupid question.  I am facing problem by filtering record from my MS SQL database on Windows2000.  For one column, some of my records has NULL value and some has nothing, which i believe space character, not null.   Wat I want to do is to be consistent my database.  I want to change all of my space character with NULL value.  Any of you guys can suggest me how to write update query to replace all the space column with NULL value.  I tried but I couldn't get the space value.     Thanks a bunch..   Regards, Jay